I would like to create a conditional format for a cell so it will turn red if
the number in the cell is not a whole number (i.e. 2.5 or 3.5 would turn the
cell red, 2.0 and 3.0 would not).

Is this possible?

Kelly

Hi!

Try this:

Assume the cell in question is A1.
Select cell A1.
Goto FormatConditional Formatting
Formula is: =MOD(A1,1)0
Click the Format button
Select the desired style(s)
OK out

Biff

"Kelly" wrote in message
...
I would like to create a conditional format for a cell so it will turn red
if
the number in the cell is not a whole number (i.e. 2.5 or 3.5 would turn
the
cell red, 2.0 and 3.0 would not).

Is this possible?

Kelly

use formula below in CF ("Formula is")

Select column A (or whichever)

=mod(A1,1)<0

then Format==Patterns== <red

HTH

"Kelly" wrote:

I would like to create a conditional format for a cell so it will turn red if
the number in the cell is not a whole number (i.e. 2.5 or 3.5 would turn the
cell red, 2.0 and 3.0 would not).

Is this possible?

Kelly

One more formula you could use:

=A1<INT(A1)



Kelly wrote:

I would like to create a conditional format for a cell so it will turn red if
the number in the cell is not a whole number (i.e. 2.5 or 3.5 would turn the
cell red, 2.0 and 3.0 would not).

Is this possible?

Kelly

--

Dave Peterson