Highlight the changing cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a data in a excel sheet which used to get update everyday once. There
are only minor changes in the data. The change can be in any cell.

I want to identify the new data. Is there any conditional formatting method
just to highlight the cell in which the values changed from its previous
value.
 
Simply make a copy of the same sheetin the same workbook and then apply
conditional formatting on any one like

=Sheet1!A1<>Sheet2!A1
 
while doing this i am getting an error "you may not use references to other
worksheets or workbooks for conditional formatting criteria"

can you explain stepwise how to do this?
 
Suppose you have a sheet named Sheet1;

Copy this sheet by left clicking its tab;

Name the sheet Sheet2;

On the last sheet, that is Sheet3, you may apply a formula like:
=IF(SHEET1!A1<>SHEET2!A1,"X","")

And, although "X" shall be highlighting the different cell you can also
conditional formatting upon the same by turning its color upon it's value
being X.
 
Back
Top