Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .