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!

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!

Dustin,

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

hth
--
steveb
(Remove 'NoSpam' from email address if replying direct)
"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!

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)

"sbell" wrote in message
...
Dustin,

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

hth
--
steveb
(Remove 'NoSpam' from email address if replying direct)
"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!

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


"Bob Phillips" wrote in message
...
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)

"sbell" wrote in message
...
Dustin,

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

hth
--
steveb
(Remove 'NoSpam' from email address if replying direct)
"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!

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

Thanks for your assistance!


"JMay" wrote in message news:AErzc.7061$qg.715@lakeread06...
But Bob...
The CF of A1 is dependent on the Value in A3;
How is [what you are suggesting] done?
TIA,,,


"Bob Phillips" wrote in message
...
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)

"sbell" wrote in message
...
Dustin,

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

hth
--
steveb
(Remove 'NoSpam' from email address if replying direct)
"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!