You're welcome. Thanks for the feedback.

Fred.

"Vic" wrote in message
...
Fred worked like a charm thank you so much!!!!
--
Vic


"Fred Smith" wrote:

=and(a1<"yes",a1<"no",a1<"N/A")

Regards,
Fred

"Vic" wrote in message
...
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

.