LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!!!!!




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reusing formula Tony29 Excel Discussion (Misc queries) 7 September 7th 06 03:34 AM
Maintain Formula Reference (sort of) JimK Excel Worksheet Functions 2 June 7th 06 05:14 PM
Copy a relative reference formula from one sheet to another. jannkatt Excel Discussion (Misc queries) 3 May 17th 06 07:13 PM
Worksheet name / reference as a formula? gabriel_e Excel Discussion (Misc queries) 4 January 24th 06 12:23 PM
Need Vlookup to work with formula in reference cell mikeburg Excel Discussion (Misc queries) 2 August 5th 05 12:54 AM


All times are GMT +1. The time now is 10:45 AM.

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

About Us

"It's about Microsoft Excel"