The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

automatic highlighting only 1st line in each group of lines in excel

(3 posts)
  • Started 5 years ago by MsLost
  • Latest reply from moreeg
  • Topic Viewed 1005 times

Posts: 1

Wow - do I have a major excel puzzel. I need to be able to automatically highlight the first line ONLY in a group of cells. For example - If I have sorted the data by column A (which is number coded) then I would like to automatically highlight ONLY the first row in the group that had the #1 in the field and ONLY highlight the first line in the group that had the #2 in the field. I would also like each group to automatically put a box around each group but I figure one step at a time. Please Help - manual takes FOREVER!

Posted 5 years ago
Posts: 566

This should be easy to accomplish with a macro. I am in the middle of something, but will look into this in a bit. In the meantime, someone else may be able to help you.

Posted 5 years ago
Posts: 842

Hi MsLost

I'll assume you know your way around Conditional Formatting (if that's not the case please come back and I'll step you through it).

The conditional rule would be


and it would apply to cells $A$2:$G$200 (you'd adjust this to the width and length of your table but it MUST start in A2 to match the conditional rule)


Posted 5 years ago

Topic Closed

This topic has been closed to new replies.