Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
click on one cell to find and highlight a related cell? | Excel Discussion (Misc queries) | |||
Highlight Cell If | Excel Discussion (Misc queries) | |||
Highlight Cell | Excel Discussion (Misc queries) | |||
When I am in one cell highlight another | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |