Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format code based on lookup from another tab
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? -- Tracey @ BrisVegas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format code based on lookup from another tab
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 On 14-Dec-2009 12:59, Tracey wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Conditional Formatting Based on Lookup into List | Excel Discussion (Misc queries) | |||
conditional format lookup | Excel Worksheet Functions | |||
If / Then based off conditional format | Excel Programming | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions |