conditional format code based on lookup from another tab

T

Tracey

Hi All,

I'm wondering if it's possible to create vba code using conditional format
principles with the source data on another tab.

I have a separate tab for each store that lists it's personnel and their
ratings. I have then summarised all of this info on another sheet using
vlookup. I would like this final spreadsheet to colour code each cell
according to their rating i.e.

Position Store1 Store2 Store3 etc
Manager Bob (red) Carol (blue) Ted (yellow)
Meat Mgr Alice (blue)
Bakery Mgr

Can I incorporate a vlookup into the sub code or would I have to create a
change criteria for every single column?
 
R

Rob van Gelder

Add a conditional format for each use of a colour.
=VLOOKUP(B2, NameColours, 2, FALSE) = "Yellow"

NameColours is a 2 column range:
Bob Red
Carol Blue
Ted Yellow
Alice Blue

Cheers,
Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format based on forumula result 5
Conditional Formatting in 2007 1
Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown 5
Conditional format based on format of another cell 4
Conditional Format to Retain Text Colour from a List on another Sh 9
Making VBA code from one WB work on another WB 2
Attempting to copy/paste data from one worksheet to another (same info but diff layout) based on dat 1
Conditional Functions - logical functions based on volatile variables 2

Top