I will try to explain what I want the end result to be. I thought it would be through using conditional formatting, but a user suggested me ask the question over here. I want to have my customer name listed in a certain cell. But when it doesn't have a specific customer name typed in the cell and it is empty, I want it to have the words "Customer Name" in a gray shade. Is this possible? And how is it done?
Thanks
Hi and welcome to the forum
Apart from using VBA, the only way I can think of to do what you want, is to have that text in all the cells in the 1st place, before you enter the customer names. However, the formatting will remain when you enter a customer name, so if you dont want it grey, you will have to reformat each time.
As far as Conditional Formatting is concerned, I dont think that will help here either, sorry
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
easy - use a worksheet change code (put in worksheet code area)
Try this :
Please click the * below if this helps
Please Login or Register to view this content.
Please click the * below if this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks