Formula

J

Jez

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
 
Z

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
 
Top