Please see attached example.
What I want is that if A1 is removed, cell F1 will then automatically switch to the value red.
Currently I am copy and pasting F1 as a value before I remove A1 but if there is a way to avoid this that would be great to know.
Not looking for anything Macro related.
Thanks
Bookmarks