Or maybe a formula like:

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

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


Debra Dalgleish wrote:

Select the cells that you want to format
Choose FormatConditional 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

Dr. Sachin Wagh wrote:
Using Conditional Formatting, how do I highlight cells that have integers &
those that have decimals?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson