I would like to apply a formula to one column that outputs formatting based on what the cell before (cell to the left of cell in column 'F') it contains.

```
IF 'E' cell is GREATER THAN 10 AND 'F' cell is LESS THAN 11, highlight 'F' cell green
```

so far my formula is:

```
=AND($E9>10,$F9<11)
```

I'm applying this formula for the entire column but I want each individual cell to be based on the individual cell before it. I'm not sure if the '$' is messing things up or what but I can't make sense of the cells that excel is choosing to highlight.

I've looked at a bunch of other posts on here based on conditional formatting per previous cell and nothing has helped. Appreciate any assistance!

An example of what it's highlighting: (bold is highlighted (there's another style being applied in the 'E' column that styles numbers 1-10))

| E | F |

| **2** | 1 |

| 100 | 34 |

| **1** | 1 |

| **3** | **3** |

| 42 | **100** |

| **6** | 5 |

| **5** | **8** |

| 11 | 5 |

| 19 | 7 |

image of issue: http://imgur.com/a/fylSF