I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell. How do I accomplish this?
Many thanks for any insight that can be provided!
Related:
Highlight date range if cell containing date falls within that range
I would like to see how your Static Date Range looks like. If you can share your sample date here, I can try to find a solution. If your excel file doesn't contain personal or sensitive data you can upload the file here:
Many thanks for the rapid response! I have provided the file with a description of how the issue relates to the file. Many thanks and I look forward to your reply!
Sorry for the delayed response. I was busy with my office work. I have uploaded your file with formatting applied change the dates and check if this works:
http://s000.tinyupload.com/?file_id=01879390551387922082
Thank you!