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