Home » Forums » Open Source Learning Center » Question and Answer

Theme colors - Excel 2010

Submitted by RMoura on 8 September, 2011 - 15:42

Hi again!

I have another question.

In Excel 2010 "Page Layout" tab, "themes" group, I can change main colors from my personalized "theme colors". Is there a way to change the colors based on main colors?

Thank you

‹ Organizing data automation import text file in excel ›
»

Excel Theme colors

Submitted by Anonymous on 24 January, 2012 - 20:48.

I want to alternate the color of cell rows. Is there an automatic way to do this?

»
Nick's picture

yes... use conditional

Submitted by Nick on 24 January, 2012 - 21:58.

yes... use conditional formatting..
input this as the formula:
=MOD(ROW(),2)=1

»