Color changing: change the color of one cell, and have other cells change colors too

Hi everyone!

What I am trying to do is an event I think.

Here is what I would like to happen:

If I change the color of a cell in Column F, then the cells after it will turn to another color.
EX. Cell F21 is changed to red, so then G21, H21, I21, and J21 turn to grey.

I'd like to be able to apply it to the whole column. So that If I change any of the cells in Column F to red, the corresponding cells in G, H, I, and J will change to grey.

Can anyone help me out with this???


Thanks!

An event macro such as a Worksheet_Change event will be triggered only if the cell value is changed not the color. A macro that you could run manually could do what you want.

Is it only row 21 that is affected or is it multiple rows? If multiple rows, what are the rows? It would be easier to help if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data.

Glad it worked out. Could you please post your solution?