Highlight date range if cell containing date falls within that range

Closed
Dispence8 Posts 3 Registration date Saturday April 8, 2017 Status Member Last seen April 8, 2017 - Apr 8, 2017 at 05:24 AM
 Zohaib R - Apr 10, 2017 at 12:26 PM
Good day!


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!


2 responses

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 8, 2017 at 05:37 AM
Hi Dispence8,

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:

http://www.tinyupload.com/index.php

Awaiting your response.
1
Dispence8 Posts 3 Registration date Saturday April 8, 2017 Status Member Last seen April 8, 2017
Apr 8, 2017 at 06:57 AM
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!
0
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 8, 2017 at 08:05 AM
I am sorry but you should provide me the link so that I can download the file on my computer.
0
Dispence8 Posts 3 Registration date Saturday April 8, 2017 Status Member Last seen April 8, 2017
Apr 8, 2017 at 08:11 AM
My sincere apologies. Here is the link:
http://s000.tinyupload.com/?file_id=01879390551387922082

Thank you!
0
Hi Dispence8,

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/index.php?file_id=09279594681714035442

Regards,
Zohaib
0