Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add background watermark to cells?
You can use WordArt to add text to your range.
InsertPictureWordArt 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Background and cells | Excel Worksheet Functions | |||
pic in watermark and in the background for EXCEL | Excel Discussion (Misc queries) | |||
How do I insert a watermark over many already occupied cells? | Excel Discussion (Misc queries) | |||
How do I put a watermark under cells in excel and make it print? | Excel Worksheet Functions | |||
How can I use a JPEG watermark as background in an excel spreadsh. | Excel Discussion (Misc queries) |