Changing a dates color once it is within 2 weeks

Ty Werven

I would like to automate a change to my date column once we are within a month, 1 week, and once the date has passed. I would like these to have corresponding colors depending on how far out the date is.

Wondering what options I have to do this? For example, I would like end dates colors to either be green if it is beyond a month out, yellow if within a month, red if within a week, and black if it is past the date.

kowal

Hi,

You can use conditional formatting for that. You just need to set it up correctly.

As those are date columns it will tell you what options you have like:

if end date is in the next 7 days red colouring

if end date is in the next 30 days yellow cell colouring

if end date is in the next 300 days green cell colouring

kowal

Hi,

You can use conditional formatting for that. You just need to set it up correctly.

As those are date columns it will tell you what options you have like:

if end date is in the next 7 days red colouring

if end date is in the next 30 days yellow cell colouring

if end date is in the next 300 days green cell colouring