Thanks Gord. Another thing I have learnt. My main reason for being involved
with this forum is that one learns so much from it and that's the second one
today from yourself.

--
Regards,

OssieMac


"Gord Dibben" wrote:

On Sat, 29 Mar 2008 17:00:01 -0700, OssieMac
wrote:

you cannot use a reference
to another worksheet or workbook in conditional format

Not entirely true.

See my reply to OP


Gord