Forum Discussion
Default/no fill colour is grey
- Mar 02, 2019
Normal style is for the current workbook only. IF XLSTART folder is empty (how to find depends on version https://support.office.com/en-us/article/automatically-open-a-specific-workbook-or-template-when-you-start-excel-be9cddc1-a148-4cbf-8f3b-779df08957a3) it's better to re-install the Office.
Simple re-install won't help since office keeps all settings, you need to uninstall with fix https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8?ui=en-US&rs=en-US&ad=US or fix manually https://support.office.com/en-us/article/manually-uninstall-office-4e2904ea-25c8-4544-99ee-17696bb3027b
The first place to look is the Normal style and see what the Fill property is set to. I use such a fill intentionally to prevent cells being displayed in areas that I have not assigned to be part of my model by declaring ranges as Input (I use white rather than the ginger default) or Calculation (also white fill).
If it is the normal style then the jolly little stripy tables would need alternate lines set to white rather than no fill.
- HHDKenyonMar 02, 2019Copper Contributor
Hi Peter,
Looks like the Fill property is set to No Shading. I can change that to white, but if I do that then clearing the fill on a cell returns it to grey, so it's not ideal.