Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

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
Avatar of Rayne
Rayne
Flag of United States of America image

ASKER

and I am using named range as well
Avatar of Rayne

ASKER

alternate formatting on the fly - like if people filter the huge data set (named range), the formatting happens then as well? possible?
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

ASKER

Nothing is better than in-the-box thing :)
Thanks Brian
Thanks, Rayne!