Change Default Cell Color (Analyst Question)

Originally Posted by Centexcel

Thank you for reading this post.

I would like to change the default color of any excel sheet I use to grey from the standard white and I am struggling to find out how this is achieved.

In other words, I am trying to have all cells in the sheets I work with appear grey on my screen by default. A coworker of mine used to work in banking and she has grey cells but does not know how she changed them.

Thank you for your time.

Try this:
First, press Alt+F11.
From the Insert menu choose Module.
In the white space in front of you paste the following code.
Go to Excel and press Alt+F8, Then double click "ColorCellsWithGrey"

Sub ColorCellsWithGrey()
Application.ScreenUpdating = False
Sn = ActiveSheet.Name
For i = 1 To Sheets.Count
    Sheets(i).Activate
    Cells.Select
    With Selection.Interior
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = -0.249977111117893
    End With
    Cells(1, 1).Select
Next
Sheets(Sn).Activate
Application.ScreenUpdating = True
End Sub

ZAX