To apply a fill color follow these steps: On the Home tab, in the Font group, click the Fill Color button's drop-down menu. The Fill Color palette appears. Use the Fill Color button to choose a solid background color to add to selected cells. Select the color you want to use in the drop-down palette. Excel's Live Preview lets you see what the cell selection looks like in a particular fill color when you move the mouse pointer over the color swatches before you click the desired color.
it worked, what did you do, since it did not work before, I had been using 2007, so I new what to do...
i am happy but just wondered what you did?
Office 2010 has been reorganized from previous versions of Excel, which can make things a little difficult sometimes.
It should always be available under the home tab.
thank you very much! have a great day. Paula