Please see attachment.
On Thu, Aug 4, 2011 at 4:29 PM, Jagadeesh B S wrote:
> Pdt Jan Feb March April May June July
> A 0.52 0.60 0.60 0.71 0.71 0.66 0.00
> B 0.72 0.72 0.71 0.86 0.96 0.81 0.77
> C 3.84 4.35 4.39 3.88 4.23 4.06 3.69
> D 1.16 1.49 1.49 1.49 1.67 1.92 0.00
> E 1.13 1.32
Select February – July data
First rule :
=(C2-B2)/B2>0.05 è Red
Second rule :
=AND((C2-B2)/B2>0,(C2-B2)/B2<=0.05) è yellow
Third rule :
=C2mailto:excel-macros@googlegroups.com] De
la part de Jagadeesh B S
Envoyé : jeudi 4 août 2011 13:00
À : excel-macros@googlegroups.com
Objet : $$Excel-Mac