View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default IF number is grather than 100 color the cell red

Take a look at format|conditional formatting.

Ron Boetger wrote:

I did this before but I can't remember how I did it. I want to have a
column of numbers and if they are greater than a certain value ie: 120
, I want the sell to have the color red.

Any ideas how to do this in Excel 2007?

THanks


--

Dave Peterson