Hi,

(Also posted on the Worksheet Functions newsgroup)

I'm looking to compare 2 dfferent schedules, same format,
same column and row headers - I just need to compare the
actual shifts people are supposed to be working.
I've written the IF statement =if(revised!D13<original!
d13,revised!d13,original!d13, which works. The problem is
that I need to then conditionally format the values that
have changed, and I keep getting an error message saying I
can't reference values in other worksheets/books in
conditional fomatting (i've tried both Cell Value is and
Formula is).
Any suggetions????
Thanks,
Chris

Hi Chris,

You can use Named Ranges to refernce values in an external worksheet with conditional formatting.

Name at least the values in the sheet external to the sheet with the conditional formatting (I would name both), then use 'Formula is: = revised_x=original_x'

Fonda

"ChrisBat" wrote:

Hi,

(Also posted on the Worksheet Functions newsgroup)

I'm looking to compare 2 dfferent schedules, same format,
same column and row headers - I just need to compare the
actual shifts people are supposed to be working.
I've written the IF statement =if(revised!D13<original!
d13,revised!d13,original!d13, which works. The problem is
that I need to then conditionally format the values that
have changed, and I keep getting an error message saying I
can't reference values in other worksheets/books in
conditional fomatting (i've tried both Cell Value is and
Formula is).
Any suggetions????
Thanks,
Chris

sweeeeeeeeet............thanks a million - you may have
just saved my job (okay, a little exaggeration, but if it
makes my appreciation apparent, that's all that matters!!)
Happy Tuesday!
Chris
-----Original Message-----
Hi Chris,

You can use Named Ranges to refernce values in an
external worksheet with conditional formatting.

Name at least the values in the sheet external to the
sheet with the conditional formatting (I would name both),
then use 'Formula is: = revised_x=original_x'

Fonda

"ChrisBat" wrote:

Hi,

(Also posted on the Worksheet Functions newsgroup)

I'm looking to compare 2 dfferent schedules, same
format,
same column and row headers - I just need to compare
the
actual shifts people are supposed to be working.
I've written the IF statement =if(revised!D13<original!
d13,revised!d13,original!d13, which works. The problem
is
that I need to then conditionally format the values
that
have changed, and I keep getting an error message
saying I
can't reference values in other worksheets/books in
conditional fomatting (i've tried both Cell Value is
and
Formula is).
Any suggetions????
Thanks,
Chris

.