How to select non_fill rows?

[sem]

Good Morning,
would you be able to help me how to select rows with no fill please?
Much appreciate any help or suggestion in advance.
See attachment for an example;

[JieJenn]

Because your background color is done using conditional formatting, so there is no manual way to delete those rows. But in VBA, it is doable. Use the file as your template.

Please Login or Register  to view this content.

[sem]

Hi JieJenn,
Thanks very very much for your suggestion it s working on your attachment book,but when i copied your code
to my different w.book i could not see the code when i press ALT+F8 is there any way you could helpme to do it without click botton?
i'm very sorry for all the trouble,and very much appreciate your time and effort.
sem

[JieJenn]

can you attach the workbook that you are currently using or pm me so we can work privately if the data is sensitive.

[sem]

Hi Jiejenn,
Thanks for your invaluable time and help i managed to insert command botton (By Google How to insert comm. botton) and copy your code
and work OK. If you don’t mind would you help me to delete rows with formatted cells (red) with condition.1) Rows with highest number of formatted cells first ,2)- if there are two rows with equally formatted cells and one row start from column (B) and the other start from column (A),then column (A) to be deleted first. this process to continue until only one
formatted cells remaining. do you think is possible?
See attachment for an example;
Thanks again and kind regards
sem

[JieJenn]

I think it should be 3 rows after the macro is ran instead of 4.

Anyway I wrote 2 procedures, one is highlight duplicates and one is delete rows with duplicates

Please Login or Register  to view this content.

[JieJenn]

Ignore my last post, I just got in to work, so I didn't read the question carefully.

[JieJenn]

Can you clarify the conditions again? Don't quiet understand what the condition should be.

[sem]

Jiejenn,
Thanks for your time and very much appreciate for being still interested on this tread.
My last request in my post #5 is to delete rows with highest numbers of formatted cells(red) first until there are only one formatted cell in each row.if you kindly look to the attachmen t(Sheet 1) you’ll see an example.I like your delete rows code but on attachment I gave an example after I run your code and if I can do the way I desire you’ll see big difference.
Thanks again
sem

[sem]

Good evening,
if its not possible to do it with code is there any way i can use formula to sum how many color filled cells

in each row with helper column?see sheet3 for example attachment;
Thanks
sem

[sem]

Any suggestion please??
Thanks

[sem]

Hi
since my first request is solved i'm going to start new tread for my second request,
thanks
sem