Stop Autofill/Highlight of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have data in various rows highlighted. For some rows, columns
A-M are highlihgted by row in a specific color. Columns N - R have data but
are not highlighted.

I am protecting the sheet so that only columns O and P are editable. When
I test data entry into the uprotected cells, then data enters fine, but it
automatically highlights (fills) with the highlight/paint color that is in
columns A-M for the same row, even though the column immediately preceding
the data entry column is not highlighted/filled.

I've tried highlighted columns N-R while unprotected and doing no fill, but
it still occurs.

Is it possible to prevent this?

Thank you for any help!
Ashley
 
Hi,

is it possible you have conditional formatting in those cells?

Regards!
Jean-Guy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to highlight cells in special order 0
Conditional Formating - by row, not by column (Office 2007) 1
Conditional Format - Formula 9
help Fill formulas, highlight cells to specified destination 1
multiple cells highlight instead of one 2
highlight duplicate rows 4
Highlighting row of active cell question 4
Summary based on highlighted cells 4

Back
Top