How do I prevent Excel from automatically styling new cells?

%3CLINGO-SUB%20id%3D%22lingo-sub-3069216%22%20slang%3D%22en-US%22%3EHow%20do%20I%20prevent%20Excel%20from%20automatically%20styling%20new%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3069216%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20Excel%20to%20keep%20track%20of%20the%20various%20calls%20I%20get%2C%20when%20something%20is%20made%20a%20problem%20and%20it's%20resolved%2C%20I%20go%20to%20the%20cell%20that%20the%20call%20was%20logged%20in%20and%20change%20the%20style%20to%20green%20to%20show%20it's%20completed.%20However%20Excel%20keeps%20entering%20new%20cells%20as%20green%20right%20off%20the%20bat.%20I%20have%20tried%20changing%20autocorrect%20rules%2C%20I%20have%20tried%20using%20conditional%20formatting%20to%20only%20style%20if%20a%20certain%20condition%20is%20met%20(which%20I%20never%20would%20meet)%2C%20I%20have%20tried%20%22Format%20as%20Table%22%20nothing%20is%20working.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20ensure%20that%20when%20a%20new%20cell%20is%20entered%20it%20STAYS%20in%20the%20%22Normal%22%20style%20until%20I%20later%20desire%20to%20change%20it%20manually%3F%20It's%20an%20extreme%20nuisance%20and%20I%20can't%20seem%20to%20find%20the%20answer%20online.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3069216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I use Excel to keep track of the various calls I get, when something is made a problem and it's resolved, I go to the cell that the call was logged in and change the style to green to show it's completed. However Excel keeps entering new cells as green right off the bat. I have tried changing autocorrect rules, I have tried using conditional formatting to only style if a certain condition is met (which I never would meet), I have tried "Format as Table" nothing is working. 

 

Is there anyway to ensure that when a new cell is entered it STAYS in the "Normal" style until I later desire to change it manually? It's an extreme nuisance and I can't seem to find the answer online. 

2 Replies
I think it's because you are manually changing the cell to green. You could create a drop down in that cell instead with the criteria required (new, pending, complete) and then attach a conditional format based on selected value in cell w drop down

@cris_no_h 

In that cell? 

I have dozens of rows that I enter each day, each row consisting of 10 unique cells. Are you saying I have to add some sort of drop down for each individual cell?