Hi, I would like to clear the contents of cells c7:g7 if the contents of another cell b7 deleted/blank. However my issue is that there is a formula in cell b7 which returns "" if false and therefore excel does not see it as "blank". Can anyone help?
Solved by S. J. in 24 mins