Solved

Matching data between different sheets

Posted on 2012-03-13
13
174 Views
Last Modified: 2012-06-21
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
Comment
Question by:keeen61
  • 7
  • 6
13 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 500 total points
Comment Utility
Check file
eeq.xlsx
0
 

Author Comment

by:keeen61
Comment Utility
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
 
LVL 39

Expert Comment

by:als315
Comment Utility
You can remove one conditional format rule (for cells in B column)
0
 
LVL 39

Expert Comment

by:als315
Comment Utility
0
 

Author Comment

by:keeen61
Comment Utility
i was able to get it work without the highlighting cells

do you have any suggestions on this
0
 
LVL 39

Expert Comment

by:als315
Comment Utility
Have you tested file from my last comment?
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:keeen61
Comment Utility
yes, i use the same formula
0
 
LVL 39

Expert Comment

by:als315
Comment Utility
Cells are highlighted in different colors? Was it correct?
0
 

Author Comment

by:keeen61
Comment Utility
none of the cells are highlighted. but the values are correct
0
 
LVL 39

Expert Comment

by:als315
Comment Utility
It's strange:
excelExcel 2007. May be different color scheme? Can you try to change color in conditional formatting?
0
 

Author Comment

by:keeen61
Comment Utility
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
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:keeen61
Comment Utility
thanks for your help
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now