Whole Number Conditional Formatting
 

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

Whole Number Conditional Formatting
 

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

Whole Number Conditional Formatting
 

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

Whole Number Conditional Formatting
 

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