Tags Tags

Add background watermark to cells?

June 21st, 2012 - 06:46 am ET by Robert Crandal | Report spam
Help Create a new topic
I have formatted cells A1 through G1 with a background fill color of
my choosing. Now I'm wondering if it's possible to add a background
watermark message to this group of cells. Basically, I want a background
message that says "Only enter integer data into this row", or something
to that effect. This background message should only be visible in
cells A1 through G1. Does anyone know if it's possible to create
such an effect?? Or, what is a good way to simulate this if Excel
doesn't provide such an effect??

Thank you!
email Follow the discussionReplies 3 repliesReplies Make a reply

Replies

#1 jaeson_cardano
June 21st, 2012 - 09:40 am ET | Report spam
Hi,

You can do this with Data Validation...

Click the Cell.
In 2007-2010, press Alt+D then release Alt then press L

Set the Allow values you want to enter into that cell, etc

For the Message, go to the Input Message Tab, there you can enter what you want to appear if the cell is selected

Copy the cell and pastespecial/validation into the other cell

For 2003-2000, same process but dont know the shortcut how to go, try it in Data Tab.


Hope it helps,
~jaeson

Similar topics

Make your own search :