Forum Discussion
Solved
Conditional formatting help
Hello, I'm trying to write a formula to conditionally highlight cells in a calendar based off starting and ending dates. I have figured out how to highlight the cells if they have the actual number ...
mac0341 It was more helpful for me to add an actual date column and then use the date to parse the day of week and the day of month. The "applies to" in the conditional format is the area below the date information, and you can see the formula I used as the rule.
Hopefully this is what you're looking to achieve.
Dexter
What is in the cells in the top rows on the right? Are they actual dates, or just letters and numbers?
HansVogelaar I have a formula to populate the days in I6 =LEFT(TEXT(I7,"ddd"),1) based off of the date that I have in I7 which is 8/4/2022, then there is a formula to generate the numbers of the month.
