I have a spreadsheet in which column E contains yearly US GDP per capita data going back to 1792. I want it to highlight every year in which the value is less than the previous year (ie, less than the cell above).
With the help of Google, I have found my way to Conditional Formatting>New Rule>Use a formula to determine which cells to format, and have attempted both "=$e3<$e2" and "=$e2>$e3" the outcome of both is that the cell with the higher value is highlighted instead of the lower.
Budget research is hard when your degree is in English and you've earned your keep playing guitar and tending bar for most of your life. I would imagine the answer to my question is perfectly obvious, but whoever answers it will earn my undying gratitude.
Excel 2010, by the way. Thanks again.
Bookmarks