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

Question

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!


System Configuration: Android / Chrome 57.0.2987.132

Zohaib R · Answer

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.

Zohaib R · Answer

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

Highlight date range if cell containing date falls within that range

2 responses

Similar discussions

Subscribe To Our Newsletter!