Whole Number Conditional Formatting

[Guest]

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

 

[Biff]

Hi!

Try this:

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

Biff

 

[Guest]

use formula below in CF ("Formula is")

Select column A (or whichever)

=mod(A1,1)<>0

then Format==>Patterns==> <red>

HTH

 

[Dave Peterson]

One more formula you could use:

=A1<>INT(A1)

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