question

AshelyDaniel-7983 avatar image
0 Votes"
AshelyDaniel-7983 asked ·

How to make a cell change red, yellow and green when expiring I. E. Training tickets valid for 1 year

Hi I

I am struggling to figure out on excel how to format cells to turn red if on today date, yellow if 90 days before today or green if within 1 year prior today

For example today 25/03/20

Go yellow if 20/01/2020

Go green if 25/06/2019

Go red if its today 25/03/2020 or further

Hope you guys can help

not-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
1 Vote"
DSPatrick answered ·

QnA currently supports the products listed in right-hand pane (more to be added) Better to reach out to subject matter experts in dedicated forums over here.


https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel


(please don't forget to mark helpful replies as answer)


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.