Conditional Format if cell value is odd

  • Thread starter Thread starter mjones
  • Start date Start date
If the cell value you want to check is A1, then:

formula is =mod(A1,2) = 0

hope that helps

Carlo
 
That formula produces TRUE if the cell value is even, not odd.

Tyro

If the cell value you want to check is A1, then:

formula is =mod(A1,2) = 0

hope that helps

Carlo
 
ISODD is not a standard function - requires ATP to be installed with
versions before XL2007.

Pete
 
So? Install ATP.

Tyro

ISODD is not a standard function - requires ATP to be installed with
versions before XL2007.

Pete
 
If you do not wish to install the Analysis Toolpak, you may use
=MOD(A1,2)<>0 to determine if a cell is odd and =MOD(A1,2)=0 to determine if
a cell is even

Tyro
 
You may also use =ISODD(A1) if you are using Excel 2007. You did not state
what version you are using.

Tyro
 
Tyro said:
If you do not wish to install the Analysis Toolpak, you may use
=MOD(A1,2)<>0 to determine if a cell is odd and =MOD(A1,2)=0 to determine
if a cell is even

Tyro
Click to expand...
 
=MOD(A1,2)<>0 to determine if a cell is odd

Or even... =MOD(A1,2)=1

Rick
 
In the future, I shall attempt to exhaust all possibilities, just to make
sure that no stone is left unturned in an answer <g>

Tyro
 
Assuming of course that the number being divided is an integer.

Being an integer was a requirement of the original question (Is value odd?).

Rick
 
I use Excel 2007.
Click to expand...

Hi all,

I'm using Excel 2003 (sorry, need to add that now), and the conditonal
format is on a range of cells so only the cells with odd numbers will
have a different color.

Sorry that I didn't clarify better.

Michele
 
Select your cells A1:A100 for example and then conditionally format with:
=MOD(A1,2)=1, then select your format color.

Tyro
 
Back
Top