Alternate Format for Huge Data Set

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
RayneAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
redmondbConnect With a Mentor Commented:
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
 
RayneAuthor Commented:
and I am using named range as well
0
 
RayneAuthor Commented:
alternate formatting on the fly - like if people filter the huge data set (named range), the formatting happens then as well? possible?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
RayneAuthor Commented:
Nothing is better than in-the-box thing :)
Thanks Brian
0
 
redmondbCommented:
Thanks, Rayne!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.