Adding formatting codes to Excel

  • Thread starter Thread starter TomG
  • Start date Start date
T

TomG

I'm sure I have to be missing something simple but I just want to add
customer formatting code to Excel to augment code that is already there.
However, I have not found a way to do this. My code is simple, something
like [red][<100]0.0;[black][>=100]0.0 but every time I open Excel with a new
sheet I am working with, the codes have to be manually typed in for the
first edit of the sheet/workbook.

Any way to do this? Thanks in advance...

Thomas Geery
 
By the way, I realize that the code [red][<100]0.0 by itself would work the
same as the code I typed in the original message but I cannot even get that
to stay in the custom list.
 
Back
Top