Hi,

I'm using conditional formatting and probably the formula rule descriptions (Excel 2010).

I am trying to change the fill of cells based on their values, but only in alternating rows (i.e., I only want to check odd numbered rows for specific values; the even rows should remain unchanged).

E.g. I would like to check row 1, 3, 5, 7, ... to see which contain the value 1 and change these cells to have the fill colour green.

Any assistance would be appreciated!