I have a sheet with a calendar with dates in row 3 and weekday names in row 4. In another tab of the sheet called 'Festivos' I have in column A a series of dates. What I would like is that these dates appear in the calendar highlighted in a different colour, and if possible that the whole column is highlighted according to a conditional formatting. I have tried with the 'match' function and with 'Indirect' but I have not achieved much.

thanks in advance

CodePudding user response：

Based on your current setup, you can use this to highlight the whole column where the formatting is applied, the date must remain at Row 3:

=COUNTIF(INDIRECT("Festivos!A:A"),B$3)>=1