Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. . |
#4
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional Formating when result is text | Excel Worksheet Functions | |||
Conditional hiding of worksheets | Excel Discussion (Misc queries) | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions |