Maybe a column of helper cells on the sheet to be colored with a formula...
=A5=OtherSheet!A5 '(returns True or False)
And use the helper cells to activate the conditional formatting.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"adhide"
wrote in message
I am aware of conditional formatting, but what I want to be able to do is
colour multiple cells on a single row based on the 1st cell (being a date)
equalling a date in another work sheet, as conditional formatting only allows
the function to work on the worksheet that the function is placed in.