Highlight the changing cell value
 

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.

Highlight the changing cell 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

"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.

Highlight the changing cell value
 

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.

Highlight the changing cell value
 

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.