View Single Post
  #1   Report Post  
dawleen
 
Posts: n/a
Default Can I use conditional formatting between two sheets to track chan.

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