Hi Steve,

If you create a table somewhere with a list of all the holidays then you can
use the VLOOKUP function for the conditional formatting of the holidays.

If you select the entire range for the conditional format the formula will
be something like this:-

=VLOOKUP(A1,$L$1:$L$10,1,FALSE)
Where A1 is the first cell of the selection and $L$1:$L$10 is the list of
holidays.

Note the relative and absolute addressing in the formula. A1 is relative and
the range $L$1:$L$10 for the holiday list is absolute.

Regards,

OssieMac


"Steved" wrote:

Hello from Steved

In Conditional Formatting Rules Manager is it possible to ask to look for
6-feb and color the text Red and the background White I use this formula to
build my Calendar
{=IF(MONTH(D3-DAY(D3)+1-WEEKDAY(D3-DAY(D3)+1)+Mtx)=MONTH(D3),D3-DAY(D3)+1-WEEKDAY(D3-DAY(D3)+1)+Mtx,"")}

Others to look for would be the first Monday in June ( Holiday ) and the
second to last Monday in October ( Holiday )

Thankyou.