display red value if true?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Let's say that I make a logical test...the test is true and it displays a certain value...

Example:
=IF(A1>0;"blablabla")
(the logical test is "A1>0" and the value if true is "blablabla"

My problem is that I need the "blablabla" to appear [Red], but only if the logical test is true. If it's false the color should be "Automatic" or whatever I've selected.

Hope someone understands my question, cus I really need a solution...

I've tried this, but of course it didn't work:
=IF(A1>0;"blablabla";IF(A1>0;[Red]General))


You got any hints???
 
Hi Atli!

You can use Format > Conditional Formatting. Either base your
condition using a formula that looks at A1>0 or base your condition on
the cell value being "blablabla".
 
Thanks a lot, it worked! ;)



Norman Harker said:
Hi Atli!

You can use Format > Conditional Formatting. Either base your
condition using a formula that looks at A1>0 or base your condition on
the cell value being "blablabla".

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Atli Bjarnason said:
Let's say that I make a logical test...the test is true and it
displays a certain value...

Example:
=IF(A1>0;"blablabla")
(the logical test is "A1>0" and the value if true is "blablabla"

My problem is that I need the "blablabla" to appear [Red], but only
if the logical test is true. If it's false the color should be
"Automatic" or whatever I've selected.

Hope someone understands my question, cus I really need a
solution...

I've tried this, but of course it didn't work:
=IF(A1>0;"blablabla";IF(A1>0;[Red]General))


You got any hints???
Click to expand...
Click to expand...
 
Back
Top