Conditional formating across worksheets

P

Patrick Simonds

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.
 
B

Biff

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
 
B

Bob Phillips

You can also use INDIRECT

=INDIRECT("Sheet1!A1")=10


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top