Solved

Excel Auto Format with Vlookup

Posted on 2013-01-25
2
450 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

707 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

14 Experts available now in Live!

Get 1:1 Help Now