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 :)
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
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 :)
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
