What icon in Excel 2007 does the pattern shading?

J

John Nettles

I do a lot of shading (Home > Font > Fill > Pattern Style) and I can not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined by
entering where it is located, i.e. see above for shading? Thanks!!
 
J

John Nettles

Thanks for responding but maybe I didn't make myself clear enough. I
understand how to get the cell shaded with a pattern, I would like to know
what the icon is called or look like. For instance the "open an exisiting
file" icon is the pic of the file folder opened with a little arrow above it.
I am looking for the "1 click" icon for doing the pattern shading (cell has
background of shaded dots). Thanks again, John
 
T

Tyro

You can modify the ribbon in Excel 2007 with VBA. The icons are in
Winows/sytem32 somehwere, I have forgotten where. Others know.

Tyro
 
J

John Nettles

I appreciate you responding but while know and understand that control 1 is a
mini-shortcut to the format cells overall box, I am looking for the icon that
is one step, i.e. like the "comma" symbol on the little icon/toolbar command
that makes the numer in the cell a "1,2345.67" format versus a 12345.67"
format a 1-step process. The older version of Excel had the icon/toolbar
command for giving a user-defined default cell pattern background but I can
not find it on the 2007 version. Thanks again.
 
D

Dave Peterson

Click on the office button (the Orb in the top left corner)
click on the Excel Options button
Click on the Customize option on the left hand side

You can modify the Quick Access Toolbar (QAT) here.

There's a Comma Style under All Commands.
 
J

Jon Peltier

This sounds like a custom button, added to the boxed version of Excel.
You'll have to similarly modify Excel 2007.

- Jon
 
Top