Hi there and welcome
this is possible, lets say the the cells are in column A, starting in B1 to check A1 you would use
You can then copy this down as far as you wish
Let me know please how you go
ok, formulas cannot change the value of another cell, only the one they are in.
What you need for this is a macro, which is coding.
Have you written a macro before Jim? If not, I would have to code it for you and for this you need to accept the request for the additional service and then provide me the sheet please