Conditional Formatting

[Dr. Sachin Wagh]

Using Conditional Formatting, how do I highlight cells that have integers &
those that have decimals?

 

[Debra Dalgleish]

Select the cells that you want to format
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)=1
Click the Format button
Select the formatting you want for integers, click OK

Click Add
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell:
=B2/INT(B2)<>1
Click the Format button
Select the formatting you want for integers, click OK, click OK

Note: numbers with .0 will be highlighted as integers

 

[Dave Peterson]

Or maybe a formula like:

=(b2=int(b2))
or
=(b2<>int(b2))

Bad things may happen when Int(b2) = 0.

 

[Debra Dalgleish]

Thanks -- that's much better.

Or maybe a formula like:

=(b2=int(b2))
or
=(b2<>int(b2))

Bad things may happen when Int(b2) = 0.

 

[Dr. Sachin Wagh]

Thanx a ton!
that's made life much easier for me!

Thanks -- that's much better.