Theme colors - Excel 2010

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

Excel Theme colors

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

Nick's picture

yes... use conditional

yes... use conditional formatting..
input this as the formula: