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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting Removal 7
Conditional Formatting VBA with formula to find string 3
conditional formatting 2
Conditional Formatting 4
Conditional Formatting macro: simple, but doesn't work 6
Excel Conditioning Formatting 3
BLINK CELL COLOUR OR TEXT BY CONDITIONAL FORMATTING 1
Conditional formatting with vba 3

Back
Top