display red value if true?

A

Atli Bjarnason

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???
 
N

Norman Harker

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".
 
A

Atli Bjarnason

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
[email protected]
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...
 
Top