• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • 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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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