Display Date format in background of CELL

I need to display DD/MM/YYYY in background of Cell . Is it possible

Thanks in advance....

Hello,

The answer to your question is yes. I have code that will do that. Attach a copy of the file and what cells it needs to be inputted in.

LeapingLizard

Thanks for prompt reply..

But I want Excel tools/formatting section.. without VB coding or macro..

Then try this;
Select the Cell where you want to make the Background.
Click "Insert" and insert a rectangular Shape in that location.
Right click on the shape - select "Format Shape"
Goto "Fill" and select "Picture or texture fill"
Goto “Insert from File” option
Select the picture you want to make water-mark
Picture will appear at the place of rectangular shape
Now click on the picture “right click” and select Format Picture
Goto “Fill” and increase the transparency as required to look it like a “Water Mark” or light background
This will get printed also.

Good luck,

LL

Thanks

Reg