Solved

VLOOKUP with conditional formatting

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to transfer Notes from Outlook 2010 to OneNote 2016 16 267
Simple Google Sheets Script question. 2 38
Index Match Array? 5 54
Excel formula that extracts out name of url 6 38
Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
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…
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 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…

685 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