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?

"FARAZ QURESHI" wrote:

Simply make a copy of the same sheetin the same workbook and then apply
conditional formatting on any one like

=Sheet1!A1<Sheet2!A1

"mrbalaje" wrote:

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.