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
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
Dexter,
I played with it again and realized I was one cell off in my reference. This works great!!! Thank you!
I played with it again and realized I was one cell off in my reference. This works great!!! Thank you!