Where the row is EVEN I need to refer to the row above in the formula and if ODD I need to refer
to the same row. How do I do that?
You need to look at the formula I posted a little closer...
Notice the part of the formula I referenced in red refers to row
3 while the blue part of the formula refers to row
2.
When creating Conditional Formatting formulas, if you select the
entire range you want to apply it to first (F3:K12), and then you enter the formula as it applies to the
first cell in your selected range (which is F3), Excel is smart enough to automatically adjust it for all the other cells in your selected range.
So, in writing a formula for cell F3, we make a cell reference to row 2 (like M2), Excel knows that you are telling it to always go up exactly one row from whatever cell you are in, for that part of the formula. You don't need to do anything special - Excel looks at the ranges in your formula relative to the cell you are entering them in for.
Try it and see for yourself!