Formula for colors

  • Thread starter Thread starter rjc44
  • Start date Start date
R

rjc44

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.
 
Select your range A8:A20
click Format>Conditional format

In the first box: formula is
in the 2nd box: =A8=SMALL($A$8:$A$20,1)

Click the format >> click on the Color box and click on re
 
Thankyou for your prompt reply.
Works perfectly and I've learned something to boot.
Kind regards
 
Back
Top