Coloring rows by value

[little_ghost]

Hi all!

I have a little question:

I have dropdown boxes in column C with the values 1 - 5 which get a color assigned by a vba script.

Is it possible to give the enire row the same color as the cell in column C?
If so, how should I do this?

I'm a compleet VBA-newbie and I've been playing around with it but I can't figure it out.

Hope someone can help me. It would be hugely appreciated.

Thanks in advanced!

Kind regards,

- Little_Ghost

[Palmetto]

Assuming the worksheet_change event is being used to trigger the code to set the cell color, this code should be close to what you are using, except that it addresses a range of cells rather than a single cell.

You will need to modify the numeric values for iColor for each of the Case statements to the same values in your exisiting code. You did not specify how many columns across to color the cells, so adjust "F" below to whatever is appropriate for your worksheet.

Please Login or Register  to view this content.