I have an Excel file with parts I need for each circuit board in my project along with a "Total" worksheet that has a list of ALL the parts from every one of the boards (collapsed into like-items of course). The "Total" worksheet is color coded (background color) in accordance with whether it has been ordered/received/not ordered/etc but I'd like to propagate those results into the proceeding worksheets. The circuit board sheets already have "=(Total![cell number])" on them to correlate but it doesn't fully show the status because it's still white. Can I make the circuit board sheets' background colors automatically change when I change the "Total" sheet?