View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I highlight numbers above or below predetermined values?

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