Improve company productivity with a Business Account.Sign Up

x
?
Solved

VLOOKUP with conditional formatting

Posted on 2014-04-09
3
Medium Priority
?
4,198 Views
Last Modified: 2014-04-10
On one spreadsheet, I have a cell in Column B that is conditionally formatted.

On another spreadsheet, I want to do a VLOOKUP that brings over the contents of the cell on the first sheet as well as highlights the cell in cell M3 on the second sheet with the data in cell B3 on the first spreadsheet and with the same conditional format color that is on the first spreadsheet for that cell. Cell M3 on the second sheet is not conditionally formatted first.

I placed this formula in Column M3 on the second spreadsheet

=VLOOKUP(A3,'[SOS Breakdown Report - 4-8-14.xlsx]14 Day Dismissal'!$A:$B,2,0)

and it does bring over the contents from the first spreadsheet, but does not bring over the conditional formatting applied to that cell on the first spreadsheet. I want the VLOOKUP to bring over both the content of the referenced cell as well as the conditional formatting for that cell as it appears on the first spreadsheet.

Is this possible? If so, how should the VLOOKUP formula be changed to accomplish this?
0
Comment
Question by:Glenn Stearns
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
rfportilla earned 2000 total points
ID: 39990802
It is not possible.  You are trying to use formatting on the source data and carry it over.  It doesn't work that way.  Formatting on the source data is wasted as this is not typically what you want to present anyway.  You are obviously doing a lookup so that you can show that data elsewhere.  This is the appropriate place for formatting.  At least, that is how Excel works.
0
 

Author Comment

by:Glenn Stearns
ID: 39991380
rfportilla...

It will work using VBA; however, this is not something I want to code for at this point. Those reviewing this post should know that it is doable via VBA. There are code snippets for this on the Web if you do a Google search for them, and there may be VBA code posts in Experts Exchange; I just have not looked for any.

Thanks!
0
 
LVL 9

Expert Comment

by:rfportilla
ID: 39992049
I agree.  I speak to people with varying degrees of Excel knowledge and unless someone mentions VBA as an option, I assume it's not.  Almost anything can be done in VBA.  This is just not a stock option without coding.  

Thanks for the clarification.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

595 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