Conditional Formatting Multiple Or Values

Phil H · #1 05-20-2015, 10:24 AM

Want to highlight any cell in a range if the value is other than Yes or N/A. Blank cells would also be highlighted.

What would the formula be?

gebobs · #2 05-20-2015, 12:56 PM

What can the cells be equal to other than yes, na(), or blank?

gebobs · #3 05-20-2015, 01:05 PM

I tried

Code:

=AND(A1<>"Yes",A1<>NA())

but that doesn't seem to work.

gebobs · #4 05-20-2015, 01:12 PM

Got it...

Code:

=AND(A1<>"Yes",ISNA(A1)=FALSE)

See attached.

Phil H · #5 05-21-2015, 04:16 AM

Here's what I wound up with: =And(A1<>"Yes",A1<>"N/A"). It works.

Thanks for your time answering my thread.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting for values with more than 2 decimals	lynchbro	Excel	6	04-17-2015 06:05 AM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Conditional formatting	marif300	Project	9	09-23-2014 07:23 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	namedujour	Excel	3	08-25-2011 01:46 PM