mtowle wrote...
Spreadsheet cell (s) are linked to other cells/calculations. The cells
in question will change value based on changes in values in OTHER cells
and based on calculations. I am using the following code to update
colors in final cells, but Worksheet_change() does not allow for
changes based on calcs. Any ideas as to how I can update colors?

Use the Calculate event handler. The Change event handler only runs
when you change the contents (formula) of cells. The Calculate event
handler can check specific values each time Excel recalcs.