N
Nicola
Hello everyone,
I looked over the internet and in this forum, but I have not found a
solution to my problem (perhaps I did not understand the solutions
that were presented on the Internet). Anyway, this is the problem:
I have two sheets, one that I use as a control (i.e. a back up) that I
will call Sheet 2, while Sheet 1 is a duplicate of Sheet 2 that is
sent out to different people for quarterly updates. I keep Sheet2
hidden in the workbook I send out for updates so that only Sheet1 is
visible.
What I want to do is make the cells in Sheet 1 automatically change
color if they are edited and no longer match Sheet1. This should be
conditional formatting, but I cannot find a workaround to Excel
limitations to conditional formatting across worksheets.
Thank you for your help
Nicola
I looked over the internet and in this forum, but I have not found a
solution to my problem (perhaps I did not understand the solutions
that were presented on the Internet). Anyway, this is the problem:
I have two sheets, one that I use as a control (i.e. a back up) that I
will call Sheet 2, while Sheet 1 is a duplicate of Sheet 2 that is
sent out to different people for quarterly updates. I keep Sheet2
hidden in the workbook I send out for updates so that only Sheet1 is
visible.
What I want to do is make the cells in Sheet 1 automatically change
color if they are edited and no longer match Sheet1. This should be
conditional formatting, but I cannot find a workaround to Excel
limitations to conditional formatting across worksheets.
Thank you for your help
Nicola