You can't. Conditional Formatting can't insert text into a cell.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Daveed" wrote in message
...
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