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
: $$Excel-Macros$$ conditional formatting based on calculation
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 1.32 1.57 1.57 1.44 0.00
F 1.14 1.29
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 1.32 1.57 1.57 1.44 0.00
F 1.14 1.29 1.29 1.29 3.12 3.18 0.00
I can to apply conditional formatting
