mardi 25 mai 2021

conditional formatting checking for a match in two different columns

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