Conditional formating across worksheets
 

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.

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.

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.


.

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.


.