Solved

VLOOKUP with conditional formatting

Posted on 2014-04-09
3
3,680 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:glennes
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
rfportilla earned 500 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:glennes
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
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…

863 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

26 Experts available now in Live!

Get 1:1 Help Now