Hi,

I am trying to write a formula to be placed in the conditional formatting to color code certain cells but am having some trouble coming up with the formula. Basically I have about 240 rows of data, the columns are by date. What I want is for whenever a daily reading is above the 20 day average of todays data and the 19 previous cells of data it will be green; and when below its 20 day average, red. The formula will start in column W, row 2. So the formula should be something like (in laymans language) "IF W2 > AVERAGE(D2:W2)" FOR GREEN and "IF W2 < AVERAGE(D2:W2)" for red. Can someone please help me with the formula?

Thanks!