Oops! worng way round. formula should be:

=AND(E1<"",E1<INT(E1))

But Kevin's formula is better.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Use Conditional formatting: Format Conditional fromatting, select
"Formula is" and enter the formula:

=AND(E1<"",E1=INT(E1))

and select the pattern colour that you want. Change the cell reference E1
to the cell that the conditional formatting is in.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"widman" wrote in message
...
How can I change the format (color or background) of a cel when its
formula
returns a decimal instead of a whole number?