LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Deleting rows which are not highlighted

Dear Experts

I have a huge data to work excel running into 8 thousand rows, I run a unique macro which highlights the data which are of interest. This macro changes the color of the first coloumn. Now I need a further request to document such differences which means I need to delete all the rows whose first row is not yellow. Can I get some help please.

Existing Conditions
1. Data running in 8 thousand+ or more rows.
2. Some rows has only FIRST COLUMN highlighted yellow because of the macro I run

Requirements:
Now I need to Delete rest of all the rows whose FIRST COLUMN is NOT Yellow.

Please can I get help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Too many rows highlighted RLD Excel Worksheet Functions 1 March 24th 10 04:33 PM
More than selected rows being highlighted RLD Excel Discussion (Misc queries) 2 March 17th 10 07:03 AM
highlighted rows excel Nick Excel Discussion (Misc queries) 1 May 19th 09 07:00 PM
Highlighted rows Reyes Excel Discussion (Misc queries) 2 November 13th 08 06:58 PM
Deleting Non-Highlighted Cells Lindsey Excel Discussion (Misc queries) 1 June 25th 08 07:29 PM


All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"