Forum Discussion

Elogan3's avatar
Elogan3
Copper Contributor
Jan 22, 2022

How do I prevent Excel from automatically styling new cells?

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. 

excel

2 Replies

  • cris_no_h's avatar
    cris_no_h
    Brass Contributor
    Jan 23, 2022
    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
    • Elogan3's avatar
      Elogan3
      Copper Contributor
      Jan 25, 2022

      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? 

Resources