How to delete non hightligthed rows from excel?

Help
, ,
1

Hi everyone. As seen from the title, I would like to know how to delete non highlighted rows.

basic summary of my program,

my program reads from an excel file, if any row has an error it will highlight the row. I want to know how to deleted the rows that are not highlighted aka the non error rows.

thanks

1 Like
2

Maybe you can do is to use Get Cell Color and do some logic on it, Like if you check the cell has color value using the Get Cell Color dont delete it else delete it. @Lydia

cheers :smiley:

Happy learning :smiley:

2 Likes
3

thanks ! ill try it out and let you know if I run into any problems !

1 Like
4

Yes Please @Lydia you can do it!

cheers :smiley:

Happy learning :smiley:

1 Like