Need help with =IF([WB1.xls]Sheet1!A1<>[WB2.xls]Sheet1!A1,"Different",""), can I highlight the different cell with cells values in it as result of for

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?
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,591
Members
412,328
Latest member
Mrcaff88
Top