|
WAY outside the box and cludgy, but maybe it will trigger your creative juices for a better fix.
Have two versions of the formatted worksheet in a workbook. Put the new data in 'sheet 2' and have it conditionally formatted to turn red (or whatever) when the data does not equal the same data in sheet 1, which was the previous version of the data.
|