You can also use INDIRECT
=INDIRECT("Sheet1!A1")=10
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Biff" wrote in message
...
Hi!
To use cf on a sheet that is dependant upon conditions
from a different sheet you have to use a defined name.
Example:
If the OP named cell A1 on sheet 1 "Sh1A1" then they could
use that to cf sheet2 A1:
=Sh1A1=10
Biff
-----Original Message-----
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.
.
|