Hi Candida

Select the cell or range of cells which you wish to format.
Right click with your mouse which brings up a context dialogue box.
Select FormatFill and use the dropdown on Pattern Style to see a range
of fill patterns.

--
Regards

Roger Govier


"Candida" wrote in message
...
I don't mean to be obtuse -- but where do I find that --- on the ribbon
bar,
or on the toolbar add-on menu, or...? I can't find it.

"Roger Govier" wrote:

Hi

Right click on CellFormatFilluse dropdown on Pattern Style

--
Regards

Roger Govier


"Candida" wrote in message
...
In the old Excel version, one could add a drop-down box to the tool
bar for
formatting the pattern color and pattern styles of a cel. It looked
and
functioned a lot like the "fill color" button.

I can't seem to find its counterpart in the 2007 version -- neither
on
the
ribbon, or in the available buttons for the toolbar. I used this
button
CONSTANTLY! Is it just called something weird now - or did they
do
away
with this very useful tool?

And if it is no longer available without opening the format
dialogue
box
every time I want to add a pattern to a cel, might there be a macro
that can
create the button for me?