Conditional format with multiple ANDs

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional format with multiple ANDs

FAQ

Thread Tools

Display Modes

02-21-2019, 01:42 PM

Intruder

Windows XP Conditional format with multiple ANDs

Office 2007

Advanced Beginner

Join Date: Dec 2010

Posts: 59

Works, great.
I don't understand, why does this formula woks: =AND($D2=3,AND($C2&$E2<>"WTO"))
and this one doesn't ? =AND($D2=3,AND($C2<>"WT",$E2<>"O"))
thanx

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional format for times	LeClef	Excel	2	07-14-2018 11:07 AM
I need help creating a conditional format	tonydoneese	Excel	5	05-28-2017 10:42 AM
How does this Conditional Format work?	Gary Drumm	Excel	7	04-16-2014 12:01 PM
Applying a conditional format to multiple rows	secoo140	Excel	1	10-12-2013 07:19 PM
Table with Conditional Format to Word	billyV	Excel	9	06-07-2013 08:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:34 AM.