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