View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default 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!