SEARCH

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

MsLost
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 1 year ago
Top
 
Enthusiast
Enthusiast
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 1 year ago
Top
 
moreeg
moreeg
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

=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 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!