How can I get the formula in my conditional format to be dynamic? for example
A B C D
1 100
2 120
3 80
4 100
5 150

How can I get the conditional format =((A2-A1)/A1)A1*.2 to be dynamic so I
can copy the conditional format from cell A2 through to A5 referencing the
cell above it?