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 in the cell but not in a blank cell corelating to the date.
In this example I am trying to write a formula so that the dates from the 17th of Aug to the 24th of Aug are highlighted in the blank squares below the dates on the right side.
Thanks in advance
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! - Dexter,
This looks like what I'm trying to achieve, and I tried duplicating it this morning, However it's not working for me. What date format did you use in your date column? Thinking that may be what is throwing it off on my end.
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.
