Highlight date range if cell containing date falls within that range [Closed]

Report
Posts
4
Registration date
Saturday April 8, 2017
Status
Member
Last seen
April 8, 2017
-
 Zohaib R -
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 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
19
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4
Registration date
Saturday April 8, 2017
Status
Member
Last seen
April 8, 2017

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!
Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
19
I am sorry but you should provide me the link so that I can download the file on my computer.
Posts
4
Registration date
Saturday April 8, 2017
Status
Member
Last seen
April 8, 2017

My sincere apologies. Here is the link:
http://s000.tinyupload.com/?file_id=01879390551387922082

Thank you!
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!