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
Mail Merge Directory Conditional Page Break 0
Cumulative formula for word table 0
Newbie Help - IF Yes No Function 0
Conditional Formatting Based On Formula Values 2
How can i put text in a cell depending on colour 0
Drop down list control value in vba 2
Document Merge Formatting Issue 0

Top