?
Solved

Alternate Format for Huge Data Set

Posted on 2013-01-29
6
Medium Priority
?
258 Views
Last Modified: 2013-01-30
Hello All,

Have 25000 rows of data, pretty huge. Want to apply conditional FORMATTING TO IT. Saw that using VBA is really time consuming and takes a long time to format the total rows in VBA. What the fastest way to alternate format rows of a huge data set.
Thanks
alternateFromatting.xlsx
0
Comment
Question by:Rayne
  • 4
  • 2
6 Comments
 

Author Comment

by:Rayne
ID: 38833066
and I am using named range as well
0
 

Author Comment

by:Rayne
ID: 38833079
alternate formatting on the fly - like if people filter the huge data set (named range), the formatting happens then as well? possible?
0
 
LVL 26

Accepted Solution

by:
redmondb earned 2000 total points
ID: 38833110
Hi, Rayne.

Depending on your Excel version, convert it into a Table. That has a default of Alternate colouring and it's on the fly!

(Select A1:G35434. On the Ribbon menu bar, select "Insert", "Table" and "OK".)

Edit: If you haven't used the Table functionality before, this is a useful introduction.

Regards,
Brian.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Closing Comment

by:Rayne
ID: 38833836
Nothing is better than in-the-box thing :)
Thanks Brian
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38833868
Thanks, Rayne!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question