How can I auto highlight a cell
 

How can I highlight any numbers that meet my requirment. e.g. I have a sheet
with 100 numbers range from 0 to 200. I want to highlight those numbers that
more than 50.

How can I auto highlight a cell
 

Hi!

Assume your numbers are in the range A1:A100.

Select the range A1:A100
Goto FormatConditional Formatting
Formula Is: =AND(ISNUMBER(A1),A150)
Click the format button
Select the desired style(s)
OK out.

Biff

"Kathi" wrote in message
...
How can I highlight any numbers that meet my requirment. e.g. I have a
sheet
with 100 numbers range from 0 to 200. I want to highlight those numbers
that
more than 50.