1

I am trying to check if a number of cells, containing multiple rows and cols, contains dates from another range (in this case days off). If the dates match I'd like to color the cell red using a conditional comment.

      | Col A      | Col B      | Col ?
    ----------------------------------------
    1 | Dates 1    | Dates 2    | Days off 
    ----------------------------------------    
    2 | ma 20 feb. | ma 6 mrt.  | wo 22 feb.
    3 | wo 22 feb. | wo 8 mrt.  | do 2 mrt.
    4 | do 23 feb. | do 9 mrt.  | do 9 mrt.
    5 | di 28 feb. | di 14 mrt. | do 16 mrt.
    6 | do 2 mrt.  | do 16 mrt. | 
    7 | vr 3 mrt.  | vr 17 mrt. | 

So in the example above cell A3 matches an off day and should be coloured red. Same goes for cell A6, cell B4 and cell B6.

Any help would be much appreciated.

1

Assuming Column ? is ColumnF, please select A:B and in Conditional formatting apply a Custom formula is of:

=match(A1,$F:$F,0)  

and select red.

MATCH

The above is case insensitive but you may need to be careful with spaces.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.