View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default Can I change the color of the largest number in a column?

Have a look at Conditional Formatting in Help,
Regards,
Alan.
"Bill" wrote in message
...
In an Excel 2007 spreadsheet I have a column of numbers that is
incremented
each month. I would like to have the largest number in that column --
which
may change from month to month -- appear in read not black. How do I
write a
formula to do that, or how otherwise do I do it?