How can I auto highlight a cell

K

Kathi

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.
 
B

Biff

Hi!

Assume your numbers are in the range A1:A100.

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

Biff
 
Top