Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
I added an Excel tag for this question. It would help if you could specify which version you're using. If you're using something other than Excel, please change the tag to the appropriate software-that will definitely impact answers. – dav May 7 '13 at 16:24
I didn't even think about it... thanks for the tip. – Kevin May 7 '13 at 16:52

Assuming Row1 is labels, the rows are as wide as ColumnZ and you want the formatting to apply to 1000 rows try =$B2>$B1 and apply to =$A$2:$Z$1000 (or adjust to suit).

Edit (hopefully for clarification):

SU592637 example

share|improve this answer
The only problem there is that I need it to highlight the entire row... that seems to only highlight the single cell. – Kevin May 7 '13 at 17:27
Did you remember to click Apply? – pnuts May 7 '13 at 17:37

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .