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

I am putting together a workbook with 52 sheets for the weeks in the year. In this workbook there are multiple columns for percentages on each sheet.

I want to be able to change the color of each cell based on whethernit increases (green) or decreases (red) from the same cell in the previous sheet.

I have the formula i.e. =IF(ISERROR(B4/D4),"0", B4/D4) to calculate my percentages but I don't know how to put the reference in for this change. Any help?

share|improve this question
I don't have access to Excel right now for a proper answer, but you should try searching Excel help and here for conditional formatting. – dav Dec 16 '12 at 1:02

If your percentages are week-on-week changes, then two rules for conditional formatting =E1<1 with red and =E1>1 with green might work (assuming your percentages are in ColumnE) but I'm not sure you describe your data in sufficient detail and 52 sheets looks excessive, as a single sheet might save duplication and unnecessary calculation.

share|improve this answer

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.