Cell referencing for condtional formatting

[Roy Gudgeon]

Hi Guys

I am trying to condtionally format cells in sheet 2 using values (stopwatch
times) listed in sheet one. However I get an error message telling me "I
cannot reference other worksheets or workbooks for conditional format
criteria"

Any way round this else otehrwise it means creating each rule individually

 

[David Biddulph]

If you include helper cells on sheet 2 which pick up the values from sheet
1, you can then use these sheet 2 cells as inputs to your CF formulae.

 

[Roy Gudgeon]

Doh !!

thanks David, pretty obvious really !

If you include helper cells on sheet 2 which pick up the values from sheet
1, you can then use these sheet 2 cells as inputs to your CF formulae.

 

[Gord Dibben]

If you name the two cells on Sheet1 you can use those names in your CF formula.

i.e. rng1 and rng2

e.g. on Sheet2 enter in CF>Formula is: =A1>rng1 where rng1 is the named cell
from Sheet1


Gord Dibben MS Excel MVP


On Wed, 20 Feb 2008 02:31:00 -0800, Roy Gudgeon <Roy