Change color of text depending on "IF" Statement?

[Dustin]

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!

 

[JMay]

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

 

[sbell]

Dustin,

Use Conditional Format with formula = "=$A$3<>0"
(remove the quotes)

hth

 

[Bob Phillips]

Don't need a formula, just used a condition of Not Equal To and a value of 0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[JMay]

But Bob...
The CF of A1 is dependent on the Value in A3;
How is [what you are suggesting] done?
TIA,,,

 

[Dustin]

Thanks to all of you my spreadsheet is working great, and I have learned how
to use conditional formatting!

Thanks for your assistance!

But Bob...
The CF of A1 is dependent on the Value in A3;
How is [what you are suggesting] done?
TIA,,,

Don't need a formula, just used a condition of Not Equal To and a value

of

0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)