Conditional Format if cell value is odd

[mjones]

Hi all,

Does anyone know how to do this?

Thanks a bunch,

Michele

 

[Tyro]

Please state your question in the body of the message, not in the subject.

=ISODD(A1)

Tyro

 

[carlo]

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

formula is =mod(A1,2) = 0

hope that helps

Carlo

 

[Tyro]

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

 

[Pete_UK]

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

Pete

 

[Tyro]

So? Install ATP.

Tyro

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

Pete

 

[Tyro]

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

 

[Tyro]

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

Tyro

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Rick Rothstein \(MVP - VB\)]

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

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

Rick

 

[Tyro]

Yes indeedy!

Tyro

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

Rick

 

[Tyro]

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

 

[Tyro]

I also understand that division by 2 can produce a remainder of only 0 or 1.

Tyro

 

[Rick Rothstein \(MVP - VB\)]

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

 

[T. Valko]

You can't directly use functions from the ATP in conditional formatting.

 

[Tyro]

I don't know what the OP has in the cell.

Tyro

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

Rick

 

[Tyro]

I use Excel 2007.

You can't directly use functions from the ATP in conditional formatting.

 

[mjones]

I use Excel 2007.

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

 

[mjones]

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

Tyro

That did it. Thanks!

 

[Tyro]

You're welcome

Tyro

That did it. Thanks!