need the first line of each cell color line group

Hello

I want to get the first line of each set of white/gray colored lines (such as circled in the image)

I couldn't think of any way of doing it but manually. Is there any way to automate this?

Thank you for you attention!

example.png

Originally Posted by mrice

Could you provide the actual sheet as the formatting is not clear from the image.

It's nice to see a question involving the Gene ontology

of course, here is a sample table

In that case, I'm looking for lines 3, 11, 20 and 38

Oh, it's rare from what I have seem, I have met so many bioinformaticians who knew how to use R but used excel manually haha

forgot attachment

Hmmm. Too bad the company just arrived, I can't check it now. But I'm very interested to find out why it's doing that. If I figure out how to correct it I'll re-post.

As it turns out, the company is late…

I found a different error (“r” was confusing row # and offset), but I don’t think the macro is selecting both elements of a two-element set. It just looks like that because the rows are adjacent. When I change the border action to making the font red, it shows that only one row is indicated.

Please Login or Register  to view this content.

Thank you! that worked like a charm!! Now I am currently trying to delete the rows with blue letters and getting my *** handed to me

Please Login or Register  to view this content.

Sorry I can't be available to help you work through this right now, but the main thing is that it isn't as simple as naming a color. There are only a few color constants and they begin with "vb" (e.g. vbRed, vbBlack, etc.). Also, they apply to the Color property, not the ColorIndex property. (It's confusing!)

In Module 1 add this:

Please Login or Register  to view this content.

Then select a cell with the blue color font and run the macro. I got ColorIndex 23, but do it yourself to be sure. Then use that index # to identify the blue font rows.

Absolutely excellent! It worked perfectly, you have no idea how happy I am for not having to do that manually hahah

Thanks Jeff and Mrice!