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.

  • 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

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.