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?