Forum Discussion
Solved
Highlight cells based on public holidays for different states
Greetings everyone, I'm trying to highlight cells in columns A:H if they fall on public holiday dates mentioned in the cells J2:L18. Now what if the public holidays differ according to different st...
zaidk4496 I would start by assigning a name to each range of state holidays, using the abbreviations used in column B.
Then the following rule, applied to columns A:H will highlight the row if the date in A is a holiday in state B:
=SUM(IFERROR(FIND($A2,INDIRECT($B2)),0))
Please find a working example attached.
zaidk4496 I would start by assigning a name to each range of state holidays, using the abbreviations used in column B.
Then the following rule, applied to columns A:H will highlight the row if the date in A is a holiday in state B:
=SUM(IFERROR(FIND($A2,INDIRECT($B2)),0))
Please find a working example attached.
