Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VLOOKUP with conditional formatting

Posted on 2014-04-09
3
Medium Priority
?
4,016 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.

610 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