How to find first and last non empty cell in row and highlight between?

[Puzzles]

Good afternoon. I am trying to figure out how to find the first and last non empty cells and then color all cells in that row between/including those two cells. If there is only one value in the row I would want to just highlight that one cell. I would like to do this for all rows until the first blank row. I would like to do this for every row starting from D6:AG6 until the last non empty row. Any help/suggestions would be greatly appreciated.

[TMS]

Something like:

Please Login or Register  to view this content.

It needs data in column D to determine how many rows to process. Pick a column that will have data in the last row.


Regards, TMS



Edit: amended as per jolivanes observation in post #3

[jolivanes]

Is this what you have in mind?

Please Login or Register  to view this content.

@TMShucks

Should that not be

Please Login or Register  to view this content.

[Puzzles]

TMShucks that was my error, which is why I repost what I do. I thought I had to have a value in D to run it effectively. Thank you so much and have a wonderful rest of the weekend!

Jolivanes thank you also for your help and have a wonderful rest of the weekend!

[TMS]

@jolivanes: you are absolutely right ... that was an oversight. Thank you for picking it up. And I even tested it twice: I moved the data to column B so that I could test your code alongside mine. And do you know why it worked? Because my test data had row numbers in the cells from D6 to D15 and, subsequently, B6 to B15. So, in each case, that line of code still picked up 15, which was the last row of data. Just goes to show how two wrongs *can* make a right

@Puzzles: thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[jolivanes]

@ Trevor
I only found out because I tried both codes.

Regards
John

[jolivanes]

Depending on your sheet setup but maybe this even works for you.

Please Login or Register  to view this content.

[TMS]

@jolivanes: the latest version works but includes the data in column B which, I think, should be excluded.

Regards, TMS

[jolivanes]

Good morning (here anyway) Trevor.
Yes, absolutely. Hence my "Depending on your sheet setup" remark.
If there is anything in the Column to the left, it won't work as it's meant to by the OP.
Have a great weekend.

John

[TMS]

@jolivanes: Sunday evening here ... too late to wish you a good weekend, so have a good week.

Cheers