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 3 years ago by MsLost
  • Latest reply from moreeg
  • Topic Viewed 1005 times


Recommended: Clean Your Mac the Easy Way with CleanMyMac 3

If you want to clean up your Mac the easy way, CleanMyMac is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyMac 3 for Free Today

Posted yesterday 
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 3 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 3 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 3 years ago

Topic Closed

This topic has been closed to new replies.