I've dug through the questions on this site and they address both problems I have, but separately. I've been trying to combine the solutions for a couple hours with no success.
Basically, I would like to use Conditional Formatting on Excel 2007 to compare two cells in a column AND highlight the entire row based on that comparison.
So, as an example... cells B1-B5 contain the same value, but cell B6 increases by 5 (the numbers only increase). I would like Conditional Formatting to Highlight ALL of row 5 and then highlight all subsequent changes in Row B as well.
I've tried adding a New Rule under Conditional Formatting and then the "Use a Formula to Determine Which Cells to Format" and this is my latest formula that doesn't work "=$E6=($E5>$E6)"
It seems like this should be simple, but I can't quite get it. Any help would be appreciated.