excel conditional formatting

  • Thread starter Thread starter Vic
  • Start date Start date
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.
 
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
 
Back
Top