Conditional formatting using formula to define date and comparing this to a selection of dates

[sandwichgirl]

Hello
I have a table that collates team holidays and I'm trying to conditional format the days where public holidays occur. At the moment I have 12 conditional format formulas per month because I can't figure out how to get the date formula to look at all the public holiday dates in one CF formula.

The date is calculated based on the year/month/day info and then it looks at a cell to say whether it matches and CFs the cell if it does. My query is whether it is possible to have a range of cells that the date formula compares to rather than just one
=DATE($B$24,$B$23,C$24)=$AA$6 - works but isn't ideal, I'd prefer it to look at $AA$6:$AA$16, can it be done?

thanks
L

 

[DanteAmor]

Change

=DATE($B$24,$B$23,C$24)=$AA$6

For this:

=MATCH(DATE($B$24,$B$23,C$24),$AA$6:$AA$16,0)

 

[sandwichgirl]

Change


For this:

=MATCH(DATE($B$24,$B$23,C$24),$AA$6:$AA$16,0)

Many thanks, all sorted and much simpler than the OR formula I had gotten to.