Conditional format formula

  • Thread starter Thread starter JEM
  • Start date Start date
J

JEM

How can I enter a conditional formula so the cell color changes based on odd
or even numbers?

Ex: even numbers - cell color is white, odd numbers - cell colors are grey
 
If I understand what you're asking, you *only* want the cell to be gray when
it contains an odd number, since it's *normally* white anyway.

<Format> <ConditionalFormat>,
Click "Formula Is",
and enter this:

=MOD(A1,2)<>0

Then select your format and <OK>.
 
RD and JEM

To clarify.

Default is "no color" which looks white.

If you format to "white", the gridlines are wiped out.

Many posters have a problem with this and wonder where their gridlines went
when they re-formatted a colored cell to "white" thinking that is the default.

But, I'm sure JEM meant default not "white" so you're correct in that respect.

Gord Dibben Excel MVP
 
Back
Top