Thanks, for some reason I couldn't get it to work so I did it manually...

Jez

"zackb" wrote:

Hi there,

Make use of Conditional Formatting. Select the cell(s) in question, I'll
assume that A1 is the Activecell. (Note: This is HIGHLY important! The
activecell can be checked by looking directly left of the formula bar; use
this cell address in place of anything below!)

Format (menu) | Conditional Formatting | Formula Is..

=A1< Int(A1)

Format as desired.


HTH, and regards,
Zack Barresse


"Jez" wrote in message
...
Hi there

I'm looking for a formula that highlights numbers that have are not whole
numbers.
i.e. 1.02

I have a list of numbers, some whole numbers othere not. I'm using office
'97