Formula
 

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

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

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

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


"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