Whole Number Conditional Formatting

K

Kelly

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
 
B

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
 
T

Toppers

use formula below in CF ("Formula is")

Select column A (or whichever)

=mod(A1,1)<>0

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

HTH
 
D

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
Click to expand...
 
Top