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.
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.