Conditional Formating of text

  • Thread starter Thread starter gilbert
  • Start date Start date
G

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...
 
Conditional formatting supports three conditions.

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