View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rjc44@iprimus.com.au is offline
external usenet poster
 
Posts: 12
Default Formula for colors

Hi,
In my range A8:A20, I have formulas which return Dollars
and cents. All the numbers are displayed in black.

How can I incorporate in my formula (it's just an If
statement), a way to change the color of the lowest number
in the range to Red.

Thankyou.