changing cell color based on date range with two dates cell

November 22, 2019 at 12:01:37
Specs: Windows 10
I have a sheet with two dates expressed as 06/19- 08/19 in one cell. I need it to change colors based on the date relative to today. Blue fill indicates the date range is in the future, yellow indicates that today is within the given range and green indicates today is past the given range. I just need the month and year expressed, can this be done or do I need to separate the dates into separate cells? there are hundreds of these date ranges so I'm trying to find the easiest option. Thanks in advance

See More: changing cell color based on date range with two dates cell

Reply ↓  Report •

#1
November 22, 2019 at 12:25:09
In your example: 06/19- 08/19

There is a space after the dash. Is this true of all the data?

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question