Font size shrinks unintentionally

[csenor]

I have been creating several workbooks with formulas and this is the first time I've encountered this. I have a data entry table on one sheet that collects vehicle fleet service records. On two other sheets I have a list of all of the vehicles and column headings with the type of service performed. I have countifs formulas with two criteria counting each time the type of service was performed. The font on the entire sheet has been changed to size 16, however when I add data to the data entry table (Excel Table), the formula cells revert back to size 11. Can anyone explain this?

 

[XLfriend777]

Hi csenor - I can not explain this behavior, but if you select all cells in the worksheet by clicking the rectangle above 1 and to the left of A you can then easily set all cells back to Font Size 16. Hope this helps.

 

[csenor]

Thanks for the reply. I have reset the formula cells to 16, but they go back to font size 11 after the sheet is recalculated.

 

[NeonRedSharpie]

Is there a Worksheet_Change event on calculate?