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

MsLost
Posts: 0

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
Top
 
Enthusiast
Posts: 0

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
Top
 
moreeg
Posts: 0

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

=A$2<>A$1

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)

Moree

Posted 5 years ago
Top
 



Topic Closed

This topic has been closed to new replies.