How do I highlight numbers above or below predetermined values?
select your range | go to Format | Conditional Formatting | select 'Cell
Value Is' | in the next drop down select 'Less Than' | in the third box,
enter the value or a cell address.
Click Add to add more conditions.
"Kurt" wrote in message
...
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!!
|