Using INDIRECT is one way

Example, suppose you want to CF cols A to D in Sheet1
if the dates in col A are found in Sheet2's col A

In Sheet1,
Select the range to be CF'd, say, select A2:D100,
then apply the CF using Formula Is:
=ISNUMBER(MATCH($A2,INDIRECT("'Sheet2'!A:A"),0))

Note that the "$" in $A2 will tie the CF for cols B to D to the date in col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"adhide" wrote:
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.