Calendar, highlight Sundays and federal holidays using CF

[geopiet]

Hi,

Trying to workout conditional formatting to highlight Sundays and federal holidays in Excel calendar.

I got the Sundays working having separate formula for every day ( I'm sure there must be better, simpler, "one for all" formula, but I failed to find one.
Anyway, it works the way it is, unless someone is willing to correct it.

My problem is to do same as above, but for federal holidays.
There is a list of holidays in Sheet2 named Federal.

PS. Excel 2007 file, macro enabled to populate any dates

Thanks

[NickyC]

Hi
this is slightly complicated by having the merged cells in your headings. There may be an easier way to do this, but these conditional formats should work:

For the Sundays:

Please Login or Register  to view this content.

For the public holidays

Please Login or Register  to view this content.

two formulas are needed for each condition as the date value can be either in the column of the formatted cell or the column to the left, due to the dates being in merged cells

[geopiet]

Thank you, works just fine.