How to change color of a cell in one sheet if its value increases or decreases from another cell value in a different sheet
- by Sean Coffey
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?