I haven't explored this, but you have have to put a cell on Sheet2 with the
formula =Sheet1!A1 and refer to that cell in your CF formula.

On Sun, 13 Feb 2005 19:56:56 -0800, "Patrick Simonds"
wrote:

Is there any way to do conditional formatting across two worksheets? So for
example if cell A1 on sheet 1 = 10 then cell A1 on sheet 2 is red.