Hightlight a range of row then a cell selected

hello evryone

i have data in range c10:h100

i want if select a cell e.g = c15 then

highlight the range c10:c100 with color

now highlight the all row only highlight defined range

thanx

Hi,

I don't understand. Suppose you select cell C30, what do you want to happen then? What about selecting C120

What's the full rule here? Are you saying whichever cell is selected in C10:H100, then colour the column that contains the selected cell, from row 10:100, and remove any previous colouring from another column?

So what are you saying. Are you meaning you have a solution or you're still looking for one.

I don't see how your code fits with your original requirement. You originally said you want to highlight a range of rows, in your original that was C10:C100.

Your code only seems to be highlighting one row.

Upload an example workbook manually coloured as necessary and tell us which was the last cell selected.