Tag Info

New answers tagged


Fastest way to check if all cells have a value between 1 and 6 is to use the COUNTIF function. Put it somewhere in your sheet, update the range and verify it returns 0. =COUNTIF(A1:Z1000,">6") =COUNTIF(A1:Z1000,"<1") Now if the result is higher than 0, use the coloring technic in the answer of Milinpatel17 to find the cells that are off.


To check that cells in excel sheet contain values between 1 and 6 do the following, Select all the cells that you want to check. the header of excel click in Conditional Formatting. In the drop down menu that appears click on new rule. A New Formatting Rule window will appear. Select rule type - Format only cells that contain. Now look at the edit rule ...

Top 50 recent answers are included