asked on Matching data between different sheets
Hi,
Please see the attached file. I would like to match column A of sheet1 and column A of sheet2,
afterwards write the values of column B in sheet1 onto corresponding cells of column C in sheet2.
it would be very nice if we can highlight each cell in column B or C in sheet2 if the two values of column B and C do not match.
It can be red if one is lower and green if it is higher.
Hope i am able to convey what i need.
thanks in advance.
fatih
eeq.xlsx
Please see the attached file. I would like to match column A of sheet1 and column A of sheet2,
afterwards write the values of column B in sheet1 onto corresponding cells of column C in sheet2.
it would be very nice if we can highlight each cell in column B or C in sheet2 if the two values of column B and C do not match.
It can be red if one is lower and green if it is higher.
Hope i am able to convey what i need.
thanks in advance.
fatih
eeq.xlsx
Microsoft Excel
Last Comment
keeen61
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You can remove one conditional format rule (for cells in B column)
ASKER
i was able to get it work without the highlighting cells
do you have any suggestions on this
do you have any suggestions on this
Have you tested file from my last comment?
ASKER
yes, i use the same formula
Cells are highlighted in different colors? Was it correct?
ASKER
none of the cells are highlighted. but the values are correct
It's strange:
![excel]()
Excel 2007. May be different color scheme? Can you try to change color in conditional formatting?
Excel 2007. May be different color scheme? Can you try to change color in conditional formatting?
ASKER
i see the same colors on the file i download from your answer.
when i try the formula on a new file cells are not highlighted.
thanks
when i try the formula on a new file cells are not highlighted.
thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks for your help
Is there a way to highlight the cells in column C only. If the value in cell C is greater than cell B then one color if is smaller another color.
thanks