How do I highlight numbers above or below predetermined values
I missed the less than.
Similat to above but this time
Formula is
enter the formula
=AND($A1<"",$A1<2)
wher 2 is your lower threshold value
Pick another colour
Mike
"Mike H" wrote:
Hi,
Select the range of numbers then
Format|Conditional Format
Cell value is - select greater than - Input a greater than number on the right
pick a colour
Click OK.
Mike
"Kurt" wrote:
I'd like to highlight numbers below a certain value or above a certain value
in a spreadsheet, thereby drawing my attention to them - help!!
|