View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 422
Default Change color of text depending on "IF" Statement?

While In cell A1, format, conditional formatting; choose formulais and in
box put:
=$A$3<0, then of course click the format button, then select the Font
Tab --text color
red, then OK out...
HTH

"Dustin" wrote in message
...
I would like the text in Cell "A1" to Change to the color red, IF the

value
in "A3" is other than "0"

Ideas?

Thank You!