Changing a cell that has a colour formatted to another colour after a period of time

You would need to add a column in your sheet that records the date the "Y" was input.

eg

Column D holds the Y's, then add an Onchange event to check Column D and if thats been updated then add the date in column E

Please Login or Register  to view this content.

Then just add another Conditional Formatting to look at the dates in column E and format as necessary.

Whats it doing? did you change the column references to match yours? is it giving an error message or doing something strange?

You'll need to give a little more info, ideally uploading your workbook or at the least letting me know where the Y's are in the sheet and where you're now storing the dates.

heres an example sheet

ive saved it as an Excel 97-2003 version now

The sheet already adds the date when you enter a Y in column D?

if the security settings are set properly then it will update column E with the date whenever you enter anything in column D (if you have other things to enter in that column and only want it triggering on a Y then add another IF statement inside the Change event to check its "Y")