Solved

Alternate Format for Huge Data Set

Posted on 2013-01-29
6
246 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 500 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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
 

Author Comment

by:Rayne
ID: 38837568
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

770 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