Using Conditional format for a range

  • Thread starter Thread starter SPenney
  • Start date Start date
S

SPenney

Can conditional formatting be used to identify odd or even numbered
cells in a range? For instance, 0.1, 0.3 and 0.5 are one color and
0.2, 0.4, and 0.6 are another? I need to combine, as I have more
conditions than it allows. Thanks!

Stace
 
Stace,

IF your range were A1:B25

***To change the format of even numbers
Select the range,
Format -> Conditional Formatting
Formula Is =MOD(A1*10,2) = 0
Set your format (for EVEN numbers)
OK

***To change the format of odd numbers
Select the range,
Format -> Conditional Formatting
Formula Is =MOD(A1*10,2) <> 0
Set your format (for EVEN numbers)
OK

Note: The formula works if your values are 0.1, 0.2, 0.3
if you have gotten to 0.1, 0.2, 0.3 by hiding decimal places
you might need to use =MOD(ROUND(A1,1)*10,2)=0

Dan E
 
Exactly,

An alternative (and perhaps slightly more intuitive) method
would be to use =MOD(A1,0.2) = 0

Dan E
 
Back
Top