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.

Cheers.

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.