I have a list of 2019 dates (col A) and holiday dates (col G). Wherever there's a date in col A that matches any date in the range G2:G20, I would like to highlight it in grey. See this sample spreadsheet
So far I have this custom formula
=$A:$A=$G$2:$G$20
...which only marks the first instance of the date range. Is there any way I can solve this without having to create a separate rule for each element of col G?
ARRAYFORMULA
. – sancho.s ReinstateMonicaCellio Feb 15 '19 at 21:28