I'm trying to make a conditional formatting rule that says: IF A1 MATCHES a date in row B or C AND is greater than D1 I can do this with two conditional rules:
=AND(match(A1, $B:$B,0),A1>=$D$1)
=AND(match(A1, $C:$C,0),A1>=$D$1)
but it doesnt work when I try to check both match statements in one conditon:
=AND(OR(match(A1, $B:$B,0),match(A1, $C:$C,0)),A1>=$D$1)
and neither does
=AND(match(A1, $B:$C,0),A1>=$D$1)
I need to do this a lot and writing them all seperately will take about a hundred CF's so was wondering if anyone knows a way of checking all these conditions in one?
Aucun commentaire:
Enregistrer un commentaire