Thank you for giving a try.

I tried your solution 2 days ago.

When cells in column A are not empty, in column B should be Yes, like what the formula from paramveer does, but then cells in column B are not blank anymore, there are formulas and your suggestion does not work, that was exactly the problem, but I solved It with VBA

.