Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

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
0
keeen61
Asked:
keeen61
  • 7
  • 6
2 Solutions
 
als315Commented:
Check file
eeq.xlsx
0
 
keeen61Author Commented:
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
0
 
als315Commented:
You can remove one conditional format rule (for cells in B column)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
als315Commented:
0
 
keeen61Author Commented:
i was able to get it work without the highlighting cells

do you have any suggestions on this
0
 
als315Commented:
Have you tested file from my last comment?
0
 
keeen61Author Commented:
yes, i use the same formula
0
 
als315Commented:
Cells are highlighted in different colors? Was it correct?
0
 
keeen61Author Commented:
none of the cells are highlighted. but the values are correct
0
 
als315Commented:
It's strange:
excelExcel 2007. May be different color scheme? Can you try to change color in conditional formatting?
0
 
keeen61Author Commented:
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
0
 
als315Commented:
Cell are highlighted in conditional formatting, not in formula. You can copy format from my example to your sheet with the Format Painter tool (little yellow paintbrush) and edit it (range and formula) in conditional formatting rules.
Here is an example of conditional formatting for similar case:
http://www.free-training-tutorial.com/animations/conditional-formatting-row.html
0
 
keeen61Author Commented:
thanks for your help
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now