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
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
Last edited by HaroonSid; 04-02-2014 at 08:51 AM.
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?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Hello Mod Richard Buttrey
i have a code who highlight entire row when select a cell
but i want only row's range e.g i select the cell c15 then highlight C row with range c10:c100
i m using this code to highlight entire row
Please Login or Register to view this content.
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.
Richard Buttrey
Sorry for wrong info
i didn't explained well what i want
but now i know what i want
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
and i found the right code
Please Login or Register to view this content.
sorry to wasting ur time
i m marking this as solved
b t w
thanx alot for ur valuable time
best regards
haroon2015
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks