Conditional format with multiple ANDs

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:31 AM.