Solved

VLOOKUP with conditional formatting

Posted on 2014-04-09
3
3,749 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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

Photo Albums in PowerPoint Photo Albums are a very useful tool in PowerPoint and allow you quickly add a large number of images. The images can be formatted in a variety of ways so that you are able to create a professional looking presentation v…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

856 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