New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Stop auto-highlighting

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Stop auto-highlighting

Postby gballi » Mon Apr 11, 2016 9:36 am

I created a basic form with titles (i.e. date, name, submitted, received, etc.) that have a filter attached. When one record is complete, I highlight it for quick reference for myself and others. Now, however, when adding new records, the new record will automatically highlight regardless if information is the same or not. It is getting very annoying to have to manually un-highlight the record. How can I fix this?
  • 0

gballi
Rookie
 
Posts: 3
Joined: Apr 11, 2016
Reputation: 0
Excel Version: 2010

Re: Stop auto-highlighting

Postby pecoflyer » Mon Apr 11, 2016 10:24 am

Hi and welcome to the board

Please post a small sample file showing the problem - Thank you
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: Stop auto-highlighting

Postby gballi » Mon Apr 11, 2016 10:55 am

Please attachment 1. This is pre-new record. Attaching the post-new record right now!
  • 0

You do not have the required permissions to view the files attached to this post.
gballi
Rookie
 
Posts: 3
Joined: Apr 11, 2016
Reputation: 0
Excel Version: 2010

Re: Stop auto-highlighting

Postby gballi » Mon Apr 11, 2016 10:55 am

This is after adding the new record.
  • 0

You do not have the required permissions to view the files attached to this post.
gballi
Rookie
 
Posts: 3
Joined: Apr 11, 2016
Reputation: 0
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 71 guests

cron