Hightlight a range of row when a cell selected Solved by : sktneer

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

Not sure that what do you want exactly? But try this code to see if this is what you want....This code is for Worksheet Selection Change Event.

Please Login or Register  to view this content.

Originally Posted by haroon2015

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

highlight the range c10:c100 with color

Then what did you write here?
Range C10:C100 exists in C column.
Probably you haven't explained well.
OK no problem.
Now tell me if you select any cell in the Range C10:H100 (say C15 as per your example), do you want to highlight the row 15 or what?

ya u right i haven't explained well

if i select c15
then highlight with color c15:h15 only

if i select d20
then highlight with color c20:h20 only

if i select e25
then highlight with color c25:h25 only

The code is exactly doing what you are asking.
If you select D20, it will highlight the range D10:D100. Isn't it? What else you want?

See the attachment.

OK. So you edited your reply. I will be back, let me correct the code.

Now see the attachment with the code which does what you want.

Glad to help you. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved.