Forum Discussion
Conditional Formatting highlighting cells using IF formula
I am trying to change the colour of any cell in the table (A:J) below if it contains M3 and N3="DT" Please help 🙂
AlanC132 -
Here's the formula I've used in my sample:
=COUNTIFS(OFFSET($B$3:$B$8,0,1),"DT",$B$3:$B$8,B11)>0