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.

"Malik" wrote:

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.