I am trying to write a macro that will change the font color of a cell if the cells value has changed. I can get it to work for cells that are manually changed but I need it to work when the value changes in a cell that has a formula populating that cell with data from another sheet. Any help is greatly appreciated!