Yes you can, you need to use a defined name (insertnamedefine) and not
something like =Sheet2!A2


--

Regards,

Peo Sjoblom



"dawleen" wrote in message
...
I need to be able to track changes between two sheets. One will be locked
and
the other able to to be edited. I want to turn any cells blue that are
changed and not equal to the static sheet. Conditional formatting won't
let
me go between two sheets. Is there any other way to do it? Thanks. D