I noticed that if I format (font, color, etc.) a certain number of cells in a row or in a column, as soon as I type text in adjacent cells in the same row or column formatting is automatically applied to the added cell. How can this automatic behavior be stopped? I'm formatting cells programmatically and style/color if often defined conditionally, it is not simply to please the eye or to make data more readable and excel's automatic formatting is setting formatting/color without knowledge of the underlying logic. Formatting is not being set via formulas but via C# code.
0
votes
"...formatting cells programmatically and style/color if often defined conditionally..." Are you using VBA, or C#? What's the code you're using? Are you in a table, or is it plain data?
- BruceWayne
I'm using C#. It's plain data which I'm formatting to speed up data reading/interpretation.
- whatever
