Resource use when using conditional formating

[Polanskiman]

Which of the 2 options below would be the most resource intensive for Excel:

Option 1: A table with X number of rows and columns each row alternating a fill color (color 1 and color 2).
Option 2: Same table as above but using a conditional formatting rule with this formula =MOD(ROW(),2)=0

Thank you.

 

[Peter_SSs]

would be the most resource intensive for Excel

I have not specifically tested but I would think Option 2 since Conditional Formats are volatile
Also, conditional formatting would most likely need to be applied to a range bigger than your data to allow for data that might be added later while the banded formatting in a formal table will automatically expand/contract with the data in the table.

 

[Polanskiman]

Thank you. Appreciate the answer.