Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

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 at 12:14

Your Answer

 
discard

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.