Change background color of cell based on vlookup in cell

  • Thread starter Thread starter Antney
  • Start date Start date
A

Antney

I have a vlookup, in a cell, which looks up color names. I want to background
color, of the cell, to change to the color based on the vlookup color name.

Can anyone help?

Thanks.
 
Conditional Formatting.

See how to in Help.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Change Color of cell 3
Changing Cell Background Color based on data from another cell 2
How to filter rows data based on background color of individual cells 1
Capturing Formatting with VLookup 1
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous 2
Change cell background color based on content that results from li 4
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel VBA 1

Back
Top