Change color from legend auto update on cells

[Lomoo]

Hello,

i have a legend with some letters with their BG colors (see attachment). When i write one of that letters in a specific range of my sheet, this letters/cells Background color should auto update according to the legend.

I would like also to have this option : when i update manually a color from legend, the letter background color should re-update according to the legend change.

Thank you in advance.

[Rick Rothstein]

First off, your second request cannot be done inside of the Change event as changing a cell's color does not raise any trappable events. Since you only have 5 colors, your best bet would be to use Conditional Formatting on the range of cells you want this functionality to apply to. I assume that range is H1:H22 (the blank grayish colored cells in your example worksheet)... I will be using that assumption in the answer to your first request. Here is how I would write the change event code for your first request...

Please Login or Register  to view this content.

[Lomoo]

Thank you, works fine.