List Validation + Colors

[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???

 

[Frank Kabel]

Hi
you can't use different colors in this listbox

 

[Guest]

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!!!

 

[Gord Dibben]

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