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

SOLUTION

als315

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

keeen61

ASKER

Thank you for your reply.

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

als315

You can remove one conditional format rule (for cells in B column)

als315

eeq.xlsx

keeen61

ASKER

i was able to get it work without the highlighting cells

do you have any suggestions on this

als315

Have you tested file from my last comment?

keeen61

ASKER

yes, i use the same formula