i would like the word "need" to appear in cells that are blank. i can do
something similar with conditional formating where the blank cells turn red
when empty... but i cant figure out how to have words inserted instead.

Thanks