Conditional Formatting Multiple Or Values

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting Multiple Or Values

05-20-2015, 01:12 PM

gebobs

Windows 7 64bit Conditional Formatting Multiple Or Values

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

Got it...

Code:

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

See attached.

Attached Files

NotYesNA.xlsx (9.4 KB, 15 views)

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:24 AM.