List Validation + Colors

  • Thread starter Thread starter Benoit
  • Start date Start date
B

Benoit

Hello,

I have a list of letter for a drop down validation.

A (Letter is black and the cell is filled in red)
B (Letter is black and the cell is filled in green)
C (Letter is black and the cell is filled in yellow)

When I select the letter in question, only the black
letter appear. the cell remains white.

What can I do???
 
A friend showed me what to do!!!

All I had to do was to select the cells (like from A1 to
D5), select FORMAT / CONDITIONAL FORMATING and do it from
there.

Little problem, you can only insert 3 conditions. Above
that, I don't know what needs to be done!!!
 
Benoit

Select the DV drop-down cell and Format>Conditional Format.

Cell Value is: equal to A. Pick a Format.

Click on "Add" and add a Format for B and again for C.

Note: this allows for just 3 formats.

If more are needed, VBA event code would be used.

Gord Dibben Excel MVP
 
Back
Top