phani.gamini
New Member
Date Performance of A Performance of B
March 11, 2013 60% 55%
March 12, 2013 70% 65%
March 13, 2013 50% 45%
March 14, 2013 80% 75%
I need to maintain the data as above for a month. So, when I enter the data for the current date, I want to apply the conditional formatting like if the current date performance of A is less than previous day it should appear in red or if the current date performance of A is greater than previous day it should appear in green.
In the above example,
for March 15, 2013 if I enter the performance of A as 75% , this 75% should appear in red (i.e. in the previous day it is 80%, so a decrease in performance, so should be in red)
for March 15, 2013 if I enter the performance of A as 85% , this 75% should appear in green(i.e. in the previous day it is 80%, so a increase in performance, so should be in green)
March 11, 2013 60% 55%
March 12, 2013 70% 65%
March 13, 2013 50% 45%
March 14, 2013 80% 75%
I need to maintain the data as above for a month. So, when I enter the data for the current date, I want to apply the conditional formatting like if the current date performance of A is less than previous day it should appear in red or if the current date performance of A is greater than previous day it should appear in green.
In the above example,
for March 15, 2013 if I enter the performance of A as 75% , this 75% should appear in red (i.e. in the previous day it is 80%, so a decrease in performance, so should be in red)
for March 15, 2013 if I enter the performance of A as 85% , this 75% should appear in green(i.e. in the previous day it is 80%, so a increase in performance, so should be in green)