Identifying % growth in a single column of cells

[chkn89]

I have a single column of values in Column A.

I want to identify specific growth patterns in this column of Cells.

Ex: I want to see when the value of cell A2 (518.5) reaches 101% (or just about). I multiplied A2*101% and it returns the cell value in C2 "523.685". In the following column I the same thing, but with 99%, with this one returning "513.315" in D2.

The values that reach this percentage in are highlighted respectively. A2 reached 101% in cell A16 (highlighted yellow). A2 reached 99% in cell A6. I would like this to be as precise as possible, +/-.03

IE:

523.685(C2) - 523.389(A16) = 0.296

513.315(D2) - 513.08(A6) = 0.235.

[JeteMc]

If I understand what you want then use the following formulas as conditional formatting rules.
For Yellow: =ABS(A$2*101%-A2)<=0.3
For Green: =ABS(A$2*99%-A2)<=0.3
Note that if 0.03 were used, then neither of the values in A6 nor A12 would be highlighted as they are in the sample.
Let us know if you have any questions.