HELP! Highlighting payroll dates, multiple criteria, vlookup, conditional formatting

[MShrewsbury]

Please help! I have been trying to work this out for the last couple hours and I haven't figured it out. Here is a link to my Facebook and Twitter where you can see a screenshot of my Excel workbook.


https://twitter.com/Love4Parrots

https://m.facebook.com/story.php?story_fbid=2468765073152417&id=100000568443530

I believe I may need conditional formatting with multiple criteria and a formula, but I am having trouble figuring it out. I am creating a payroll calendar and I want to highlight the dates for weekly, semi-monthly, monthly clients. Each one needs to be a different color.

I have a small yearly calendar. I need the date in the calendar to match my list of key dates. To the right of the calendar, is a two-column table with the headings: key dates and description.

The description includes the words weekly, monthly, semi monthly.

If the calendar date matches at date, I need it to fill the cell based on the corresponding color. If the calendar date is in a cell filled yellow, I need the date on the calendar, the cell, to be highlighted in yellow. And the same goes for the other payroll frequencies / colors.

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...ble-if-statement-post5219956.html#post5219956

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it. Please be patient and do not attempt to post the question again.