Conditional Formatting and programming???

[ChrisBat]

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

 

[Fonda]

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]

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'