I have question. We are making a planning tool for one of our internal products. In this tool we can switch the status of an item (in this case a package) manually (drop down menu)(column E). Based on the status it is ending up in one of the employees planning overview tabs. But, every packages has an offline date (column G). This date is the moment that the package will go offline automatically. Based on the offline date I would like to switch the cell status automatically to 'Offline'. The problem is that this cell could also be changed manually (for other status).

I was thinking, may be there is a trick with conditional formatting to also change the value / text inside a cell. When the present date is the 'offline date' or later than the offline date the conditinal formatting will change the status of the cell to: "Offline".

Does anyone have a trick for this? Thank you in advance!

Link to example sheet:

After: