Conditional Formatting Watermarks

Question

Hi,

I would like to place a watermark on my spreadsheet but on when a certain cell is a particular word.

IE- Cell A1 is a drop down list of three options(Hourly,Daily,Fixed Fee)

I have a watermark on the middle of the page currently but only want that watermark to appear if "Fixed Fee" is selected from A1.

Is this possible to do?

Thanks

Bryan

Answer 1

Right click on the tab for the relevant worksheet, select View Code and paste this subroutine into the the resulting module. You should first click on the image to find its name - then change 'Picture 1' to the correct name. best wishes

Private Sub Worksheet_Change(ByVal Target As Range)

Dim rng As Range

Set rng = Range("A1")

If Not Intersect(Target, rng) Is Nothing Then

  If UCase(Range("A1")) = "FIXED FEE" Then

     ActiveSheet.Shapes("Picture 1").Visible = True

  Else

      ActiveSheet.Shapes("Picture 1").Visible = False

  End If

End If

End Sub

Answer 2

Good to hear.

Please mark my first message as Answer

cheers

Answer 3

Great. This works perfectly! Thank you!