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:
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