Thread: Conditional format with multiple ANDs
View Single Post
 
Old 02-21-2019, 01:42 PM
Intruder Intruder is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default
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
Reply With Quote