View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sunny FL Sunny FL is offline
external usenet poster
 
Posts: 7
Default How do I highlight numbers above or below predetermined values?

Use Conditional Formating...Highlight the column you want to apply this
"rule" to. Then click on FORMAT/CONDITIONAL FORMAT.

Then you can choose a number of rules, or just one? Up to you.

Hope that gets you started. If you get stuck. Write back.

--
Sunny FL


"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!!