formula to shade designated cells

Hey there,

I currently have a spreadsheet with about 5 different tabs (pages). Is there a way that I can shade a specific cell on one page, and have it automatically shade another designated cell on a completely separate page? Although I can do it all manually, I'd like to be able to save some time and have it shade the assigned cells automatically for me.

I hope this makes sense. Thanks for any advice you can provide with this!

-w

You'll need to provide more data or, even better, upload some example with explanation what and when you want to shade

I am attaching two sheets and hope it will clear your question.

Thanks for your input...I think this information should point me in the right direction.

Not sure how to place this thread in the "resolved" category.