Been searching around here but haven't found exactly what i am looking for. I have one column on one sheet, where I'd like the color to be green if that cell was changed or updated today, if it has been a few days since the last change maybe a slightly darker green and more than a week lets say red. (colors are irrelevant, just some way to signal that time has passed since the last update.) and then if no information is entered the cell should remain white. This column is updated manually with no other formulas referencing it. Hopefully this makes sense. Thank you!