Insert Text using Conditional Formatting

**kyandbe24** · 06-24-2013, 01:52 PM

I will try to explain what I want the end result to be. I think it would be using conditional formatting, but not sure. Just for ease, cell A1 I want to have my customer name in it. When it doesn't have a specific customer name typed in the cell and is empty, I want it to have the words "Customer Name" in a gray shade. Is this possible? And how is it done?

Thanks

**Craig K.** · 06-24-2013, 02:51 PM

Conditional Formatting will not insert a value (text or numeric) into a cell. If you want to have the value "Customer Name" in a cell, you need to populate it yourself. You can try going on to the VBA board, and asking if they can assist.

**kyandbe24** · 06-24-2013, 08:00 PM

Originally Posted by Craig K.

Conditional Formatting will not insert a value (text or numeric) into a cell. If you want to have the value "Customer Name" in a cell, you need to populate it yourself. You can try going on to the VBA board, and asking if they can assist.

Thanks. I will try asking it in the VBA forum