View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Qull666@hotmail.com is offline
external usenet poster
 
Posts: 114
Default Watermark: (reference formula ie. Vlookup or IndexMatch)

Good Day,

Its like this, when a certain document is paid in the post office or any
other agencies or like in the movies, the person attending the matter would
stamp PAID (with the date, cheque number or other information).

I have seen Ron De Bruin's watermark stuff. There is a box switch to trigger
the watermark. If the trigger can be shifted in another way.

I have this little status boxes that shows item 1-3 below, but lets go bold,
THE WATERMARK!!!!..

I have 3 requirements that triggers and change the wording of the watermark.

1. Paid - Cheque Number - Date - etc.....
2. Waiting for Official Receipt
3. No Watermark (Not Paid) or NOT PAID in watermark.

(Vlookup is there, Index Match, If stuff are also used)

This is for on-screen graphical and printing

Holler: THANKS FOR THE HELP!!!!!