Thank you for the quick reply, looks like the solution I was looking for. If you do not mind can you please explain to me how you did the DIFF part and the Update part? so that I can learn to do it as well.
Edit: Did not see the attached solved workbook. That answers my question, thanks a lot Sir.
1 of 1 people found this helpful
This is the Calculation for Difference
FORMULA is (p2-p1)/p1
(SUM([Current Sunday])-SUM([Previous Sunday]))/SUM([Previous Sunday])
Then I wrote this 2nd calculation for Update, Drageed it to Color and changed Shape to Square and SIZE to Full
IF SUM([Current Sunday])<SUM([Previous Sunday]) and [DIFF]<= -0.1
Hope this Helps!!
Please Take a sec to Mark my Answer CORRECT to Close Thread.