I have a workbook with 53 sheets, one for each calendar week plus one for yearly. Each sheet has columns for percentages for each shift(1st, 2nd, 3rd). What I want to do is change the color of the cells that increase(green) or decrease(red) from that of the same cells on the previous sheet in order to keep track of progress from week to week. The problem is I don't know how to do it or how to incorprate into the formula I have for these cells. The formula I am using for my percentages is [ code ]=IF(ISERROR(B4/D4),"0",B4/D4)[ /code ] .
Book1 - Copy.xlsx
Bookmarks