Demosthenes&Locke
Board Regular
- Joined
- May 11, 2010
- Messages
- 93
I am going to create a workbook to do a comparison between two different workbooks so I do not have to open the other workbooks, and I was wondering, can I make it change the coloring of the cell and show the contents of the cell?
WB1 will always be the newer workbook, so changing the formula as such,
=IF([WB1.xls]Sheet1!A1<>[WB2.xls]Sheet1!A1,[WB1.xls]Sheet1!A1,"")
will show a changed object, but I plan on having it show the older object as well, and I would like to highlight the changed object.
Is there a way to make it highlight a cell within a formula instead of vbscript?
Does conditional formatting have the ability to tell which workbook the cell value was taken from?
WB1 will always be the newer workbook, so changing the formula as such,
=IF([WB1.xls]Sheet1!A1<>[WB2.xls]Sheet1!A1,[WB1.xls]Sheet1!A1,"")
will show a changed object, but I plan on having it show the older object as well, and I would like to highlight the changed object.
Is there a way to make it highlight a cell within a formula instead of vbscript?
Does conditional formatting have the ability to tell which workbook the cell value was taken from?
