Forum Discussion

j99m00r3's avatar
j99m00r3
Copper Contributor
Jun 30, 2023

Expiry dates help

Hello,

 

I am trying to make a spreadsheet with an expiry date column and was wondering if there was a way that I could set up some conditional formatting to make the dates I put into the expiry column change colour depending on the date?

 

This is the sheet:

 

So I would put a date in column "I" as a date, i.e. 30/06/2024, and then it would stay green up until 2 months before that date (30/04/2024) at which point it would turn amber, and then once it got to 30/05/2024 it would turn red to indicate I have a month to buy new paint. 

 

Any ideas? Thanks!

Resources