On Jan 7, 10:34*am, Jock wrote:
If, for instance, "paid" is selected in cell K5, is it possible to
automatically have 'paid' appear in large font accross the range (D5:G8) like
a watermark?
--
Traa Dy Liooar

Jock

Yes, it is possible. I am assumign that you have a pull down for the
paid column. Merge D5:G8. Enter this formula into D5
=IF(K5="Paid","Paid","")

You can also nest more ifs together to make the watermark multiple
things. Like =IF(K5="Paid","Paid",IF(K5="Donkey","Donkey",""))
Jay