You posted the first question and then the last question in a separate thread at: http://www.excelforum.com/excel-prog...ther-cell.html

For reasons to cross-post or not see: http://www.excelguru.ca/node/7

Changing font color does not trigger a sheet event. We can trigger based on precedent cells and dependent cells to some degree. It is better though to just use a Change event to color the text in the cells as needed based on cell value changes. Changes based on formulas require Intersect and Precedent techniques in the Change event for the sheet.

Conditional formats might be a route for part of it. I don't think that it will handle both cases though.