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

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.
--
David Biddulph

"Roy Gudgeon" <Roy wrote in message
...
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

Doh !!

thanks David, pretty obvious really !

"David Biddulph" wrote:

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.
--
David Biddulph

"Roy Gudgeon" <Roy wrote in message
...
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

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 CFFormula is: =A1rng1 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
wrote:

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