Solved

Excel Auto Format with Vlookup

Posted on 2013-01-25
2
453 Views
Last Modified: 2013-01-25
Hello,

I need to perform a vlookup and find a value within an array and if "true" then the value cell should be auto-formatted (i.e. highlight yellow).  How can I accomplish this?  The attached provides a basic example to work off of.  Thank you.
NEED-HELP.xlsx
0
Comment
Question by:rgarzakavo
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 38818963
Select the column C range and go to Home|Conditional Formatting|New Rule

Then select "use a formula to determine which cells to format"

Then enter formula:

=MATCH(C1,$A$1:$A$9,0)

Click format and choose yellow from Fill tab.
0
 

Author Closing Comment

by:rgarzakavo
ID: 38819515
AWESOME!  Thank you.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Display multiple images in report 12 118
Office 2016 User Guides 5 37
Where is user Lync data stored 4 86
Automatic sort formula 8 53
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

777 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