A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Programming
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Add background watermark to cells?



 
 
Thread Tools Display Modes
  #1  
Old June 21st 12, 11:46 AM posted to microsoft.public.excel.programming
Robert Crandal[_2_]
external usenet poster
 
Posts: 158
Default Add background watermark to cells?

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!


Ads
  #2  
Old June 21st 12, 02:40 PM posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Add background watermark to cells?

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
  #3  
Old June 21st 12, 02:42 PM posted to microsoft.public.excel.programming
Gord Dibben[_2_]
external usenet poster
 
Posts: 623
Default Add background watermark to cells?

You can use WordArt to add text to your range.
Insert>Picture>WordArt
Light color with 100% transparency.

Or use a Data Validation input message in each cell.........when user
clicks on the cell message pops up.


Gord

On Thu, 21 Jun 2012 03:46:48 -0700, "Robert Crandal"
> wrote:

>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!
>

  #4  
Old June 21st 12, 02:44 PM posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Add background watermark to cells?

Note: When you are in Input Message Tab, the "Show Message when the Cell is selected must in Checked.

Thanks,
~jaeson
  #5  
Old December 30th 16, 05:27 PM posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Add background watermark to cells?

On Thursday, June 21, 2012 at 4:16:48 PM UTC+5:30, Robert Crandal wrote:
> 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!


  #6  
Old December 30th 16, 05:27 PM posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Add background watermark to cells?

On Thursday, June 21, 2012 at 4:16:48 PM UTC+5:30, Robert Crandal wrote:
> 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!


  #7  
Old December 30th 16, 05:35 PM posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Add background watermark to cells?

On Thursday, June 21, 2012 at 4:16:48 PM UTC+5:30, Robert Crandal wrote:
> 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!


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Background and cells welska Excel Worksheet Functions 2 November 26th 06 11:58 PM
pic in watermark and in the background for EXCEL vcff Excel Discussion (Misc queries) 0 November 22nd 06 12:41 AM
How do I insert a watermark over many already occupied cells? Patrick Padovani Excel Discussion (Misc queries) 1 August 15th 06 12:32 PM
How do I put a watermark under cells in excel and make it print? Watermarks Excel Worksheet Functions 1 July 1st 05 05:49 PM
How can I use a JPEG watermark as background in an excel spreadsh. TerraTech Excel Discussion (Misc queries) 1 February 15th 05 01:11 PM


All times are GMT +1. The time now is 06:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.