Hey folks! Long time browser, first time poster.
Ok. I have a spreadsheet with almost 5000 lines of data. I need a macro that will separate blocks of 100 lines at a time, each block of 100 filled with a different color. Maybe 3 or 4 colors will work.
To make it even more difficult, I also want to check macro to make sure the Data in column i after the 100th cell doesn't match the previous cell. If it does, then to color that cell as well.
Attached is a sample of what i would like it to look like. You will see line 101 matches 100 so it is colored the same as the first 100. Line 301 and 302 match the previous cell, so it selected them.
Any help you can provide would be great.
Last edited by MrDubleTruble; 11-19-2010 at 02:36 PM. Reason: Added sample xls and corrected
Doesn't match what?
Create a sample workbook with a 1000+ rows of data, then show BEFORE and AFTER versions of that sheet demonstrating all the hurdles that have to be overcome. Show us what you're after and why and explain the logic of each the choices you make as you manually color up your sample AFTER.
Click GO ADVANCED and use the paperclip icon to post up your workbook.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
I edited the post with the info requested.Originally Posted by JBeaucaire
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks