I've got a spreadsheet with multiple workbooks, and if I set a cell
worksheet1 to be purple, I need a corresponding cell on worksheet6 to
also turn purple, and vice versa. Is there any way to automate this?
Manual colorchanging across multiple worksheets is tedious,
timeconsuming, and has lead to inconsistencies before. I'd love to
eliminate any "human error", if at all possible. Thanks!