excel conditional formatting

V

Vic

I need to write a conditional formula that will result in a highlight of the
cell if the cell value is not one of these three "yes", "no", or "N/A".
Can't get it to work. Can anyone help me.
 
N

Nadine

The first two are:
Condition 1: Cell value is equal to ="Yes"
Click Add at the bottom of the dialog box
Condition 2: Cell value is equal to ="No"
Choose the format for each one as you want them to be.
Maybe someone else can help with the #N/A piece of this.
Nadine
 

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

Conditional Formatting 3
Excel conditional formatting with Weeknum 4
Conditional Formatting #n/a 2
conditional formatting - problem with text cell value from formula 2
Excel Conditional Formatting Removal 7
Comparison of columns using Conditional Formatting 3
Conditional Formatting Problem 3
Conditional Formatting 7

Top