Tag Info

New answers tagged

0

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.


2

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