Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?

share|improve this question

Use Format -> Conditional Formatting with two conditions with these formulas:

  1. =MOD(ROW(),2)=0
  2. =MOD(ROW(),2)=1

then apply your custom format.

share|improve this answer
Format -> Conditional formating brings up a box. Clicking + to add a rule gives me a choice of 2 color scale, 3 color scale, Data bar, icon sets, classic. Checking each of these in turn shows no place I can enter a formula. Mac Excel 2011 – Sherwood Botsford Feb 13 '14 at 12:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.