Excel 2007 : Conditional Formatting Based on Percentage Change

I am trying to create a conditional format that will highlight a cell red when it is a 20% increase from the row (cell) above.


Example:

-- A ------------------- B -------------------- C ---------------- D --------------- E ----------------- F ---------------------
Wk 1 ------------- Wk 2 ------------- Wk 3 ----------- Wk 4 ----------- --Wk 5 ----------- Wk 6 -------------
1 176,468 ------ 205,282 ------ 435,225 ------ 457,112 ------ 517,754 ------ 606,123 ------
2 276,479 ------ 351,123 ------ 225.874 ------ 124,987 ------ 741,912 ------ 904,413 ------

I want the conditional format to highlight A2 as red if it is 20% higher than A1. Then have this formula be copied and pasted to apply to all other cells, while changing the cell the conditional format is referring to. I was attempting to do it based on a formula =A1*1.2>A2 then highlight red, but wasn't sure how to get these to apply to the other cells without having them all refer to A1. The format painter wouldn't change the original reference cell. Any suggestions?

Thanks,
Dan

Try this

Formula is:=
=A3/1.2>A2

Applies to:=
=$A$3:$F$10

Hope this helps