Insert text based on cell color

[kstrain]

I have a workbook set up that if a value is changed in column F, it highlights the cell green. If it goes unchanged, there is no fill color. Is there a way to put a formula in cell F1 that says, if a cell color in column F is green then show text “Special” and if there isn’t a cell in column F that is green then leave cell F1 blank?

I would be sending this file to others to review and the data in column F will be changed by them. I am hoping it can be something that automatically happens where they won’t have to run a macro to populate the text in cell F1 if a cell changes color.

 

[Micron]

If you can do that with a formula I'll be amazed, hence me posting here to see whether or not someone says yes. I say not with formula, only with vba code.
They don't have to always manually run code - you can make that happen with sheet events such as just moving from one cell to another. There are several events to choose from. I suppose none of that is of any use to you if others are restricted from using files that contain working code.