Hi,

Just wonder if we can set preferred colour text to the text appearin
using If, Then, Else function? For example, a function having th
following :-

=if(A1="","Error","OK")

I want the word "Error" to appear in red colour when cell A1 is i
blank and the word "OK" to appear in blue colour when cell A1 is fille
up. I know we can do it using Conditional Formatting but that is onl
for 1 condition, but for my situation, there are two conditions.

Please help...

--
Message posted from http://www.ExcelForum.com

Conditional formatting supports three conditions.

Hit the add button in conditional formatting to define the second (and
third) conditions and formatting.

--
Regards,
Tom Ogilvy

gilbert wrote in message
...
Hi,

Just wonder if we can set preferred colour text to the text appearing
using If, Then, Else function? For example, a function having the
following :-

=if(A1="","Error","OK")

I want the word "Error" to appear in red colour when cell A1 is in
blank and the word "OK" to appear in blue colour when cell A1 is filled
up. I know we can do it using Conditional Formatting but that is only
for 1 condition, but for my situation, there are two conditions.

Please help....


---
Message posted from http://www.ExcelForum.com/