Hi All,
I don't know if this is a common and silly question, however, i would like to check if a cell is blank/empty and if so write some text in it, however, i want to put the formula in a hidden cell and and have it check another cell and output the text there...
e.g. Put the formula in A1 to check if B1 is blank and if it is blank automatically add "put your text here" in B1
Hope this makes sense? Is this possible without macro's etc?
OR is there a better way to achieve this outcome?
Cheers,
Darren
Bookmarks