This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I extract a report into Excel daily. I manipulate and copy and paste different sections into different sheets that I have created within that workbook. I use color coding a lot. How can I color one line in the master sheet and have the same line automatically change color in the other sheets? And, can I make it so that it works the other way around too, so if I color code something in one of the other sheets, it will update in the master sheet.
TIA!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Excel doesn't work that way.
If you color cells or ranges based on specific conditions, you can apply conditional formatting to both the source range and target range. That way the formatting will remain coordinated.