Conditional Formatting Based on vlookup Value

  • Thread starter Thread starter Excel User
  • Start date Start date
E

Excel User

I have the following on one worksheet:

A B
School 1 (formatted in green) Nickname 1 (formatted in green)
School 2 (formatted in blue) Nickname 2 (formatted in blue)

On my second worksheet I have a cell that looks up school and returns
corresponding nickname using vlookup. What I need is to have the cell with
vlookup also show the formatting. So if that cell looked up Nickname 1, it
would have green formatting.
 
Please keep in mind that there are hundreds of school names, so stringing if
statements for each school is not practical/possible. Thanks.
 
Formulas cannot return color formats so you would have to use Conditional
Formatting or event code.

If you did find a solution, keep in mind that Excel is limited to 56 colors
so the "hundreds of schools" being a unique color is impossible without
extensive code.


Gord Dibben MS Excel MVP
 
Thank you Gord. I am not looking for unique colors for each school, just a
way to format both text and cell fill colors based on the content and format
of the cell it looks up.
 
Back
Top