MShrewsbury
New Member
- Joined
- Feb 4, 2019
- Messages
- 2
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.
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.