Conditional Formating of text

[gilbert]

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

 

[Tom Ogilvy]

Conditional formatting supports three conditions.

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