Excel 2010 conditional formatting help

[Executioner]

Hi everyone,
I'm having issues with Excel's 2010 conditional formatting. Seems easy to use, but I'm trying to highlight values based on 2 columns of numerical data. Example:
Column F:
6
6
14
Column L:
3
NA
17

I would like Column L to highlight values that are greater than Column F in green. If they are less than Column L then highlight them in red.

Seems I was able to do this with Excel 2003, but I don't understand the 2010 version.

 

[ZAX]

Enter this formula in the conditional formatting of column L :

=L1>OFFSET(L1,0,-6)<offset(l1,0,-6)>

ZAX</offset(l1,0,-6)>

 

[Scott Huish]

or
=$L1>$F1

and

=$L1<$F1

 

[Executioner]

Thanks guys. I think I figured it out after asking another person (we both struggled but got it working). After creating the rule for cell L2, I copied and pasted special for formatting on the rest of the column.

Here is a pic:

I like having more that 3 selection criteria in 2010, but I found the 2003 version easier to use.