The first two a
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

"Vic" wrote:

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.
--
Vic