Conditional Formatting Help Needed

here is the spreadsheet
Time-and-Payments.xlsx

Select cells C4:I17 and use a formula criteria like:

=MATCH(--SUBSTITUTE($B$2,","," " & C4 & ","),PayDates,0)

Select allOpen in new window

Time-and-Payments.xlsx

The only thing is it is turning Feb 3rd green and it is not a paydate

Does this work as desired?
Time-and-Payments.xlsx

You made a lot of extra work by choosing to display dates as text. The better way to do it is to display a real date in each cell, then format the date with ddd if you want the day of the week or d if you want just the day number.

I changed all of your date formulas to be real dates instead of text, then modified the Conditional Formatting accordingly.
Time-and-Payments.xlsx

Mark,

Did the attached file in the accepted solution work for you? Did you try to change the month on setup sheet and did you find everything normal on Month  Sheet?

Thank a lot byundt. Now i just need to try and fix the conditional formatting for the holidays. for some reason it all works great except for March, June, and November. On those months it turns all of the white dates to pink.

Thanks again.

after doing some more looking on what you sent the paydates are working perfectly but none of the paid holidays are showing up on the calendar.

Subodh,

No it did not work. none of the paid holidays would show and neither did the paydays

OK i was able to fix the holidays byundt simply by changing you formula for paydates to =MATCH(C4,HolidayDates,0)

Thanks