I would say it can be done.

I will work on it and come up with a workbook I can send to you.

Email me if you want this to happen.

Change the AT and DOT to get my address.


Gord

On Wed, 9 Jan 2008 04:37:00 -0800, Jock wrote:

Interesting stuff Gordon, but can I ask a bit more??
In colomn K, every 4th or 5th line will have a drop down list in which one
of the options is "Paid".
When the option "Paid" is selected, I'd like the rectangle to appear (with
paid in it) from the cell immediately to the left back to A on the same row
and down four rows.
Is that sort of scenario do-able?

Cheers