Formula

[Guest]

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

 

[zackb]

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

 

[Guest]

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

Jez

 

[Guest]

You can simplify that by using "Cell Value" and "Is not equal to" and =Int(A1)