Aug 25 2022 02:20 PM
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
Aug 25 2022 02:38 PM
What is in the cells in the top rows on the right? Are they actual dates, or just letters and numbers?
Aug 25 2022 04:05 PM
Solution@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
Aug 26 2022 04:13 AM
@Hans Vogelaar 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.
Aug 26 2022 04:24 AM
Aug 26 2022 04:51 AM
Aug 25 2022 04:05 PM
Solution@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