How do I change color of cells, columns and rows in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johnny434 - 11 Jul 2006 03:20 GMT

I cannot seem to be able to change the background colors of columns, rows and
cells in Excel. I had no problem when I was using Office 97.
How can I do this with Office 2003?

Reply to this Message

Gord Dibben - 11 Jul 2006 03:46 GMT

Can you see the colors when in Print Preview or when you print the worksheet?

If this is a problem with all Excel files, the Windows OS
high contrast setting may be turned on. There is information in the
following MSKB article:

OFF: Changes to Fill Color and Fill Pattern Are Not Displayed

http://support.microsoft.com/default.aspx?scid=kb;en-ca;320531

Gord Dibben Excel MVP

>I cannot seem to be able to change the background colors of columns, rows and
>cells in Excel. I had no problem when I was using Office 97.
>How can I do this with Office 2003?

Gord Dibben MS Excel MVP

Reply to this Message

Bob Phillips - 11 Jul 2006 08:52 GMT

Gord,

That link has changed

http://support.microsoft.com/default.aspx?kbid=833258
The fill color, the fill pattern, or the line color of a WordArt or
AutoShape
object in an Office document does not change

and unfortunately, MS do not automatically re-direct.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Can you see the colors when in Print Preview or when you print the worksheet?
>
[quoted text clipped - 13 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message

Gord Dibben - 11 Jul 2006 15:54 GMT

Thanks for re-reminder Bob.

I think you or Debra already pointed that out to me.

Now, what did I have for breakfast???<g>

Gord

>Gord,
>
[quoted text clipped - 6 lines]
>
>and unfortunately, MS do not automatically re-direct.

Gord Dibben MS Excel MVP

Reply to this Message

Bob Phillips - 11 Jul 2006 16:11 GMT

It must have been Debra, for it was she who pointed it to me. Good job
someone (Debra) is on the ball <g>

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Thanks for re-reminder Bob.
>
[quoted text clipped - 16 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message

Johnny434 - 12 Jul 2006 02:54 GMT

Thanks for trying! I have found out what the problem was. The icons were
hidden. I didn't click the little down arrow to display the icons! Duh!
Johnny

> It must have been Debra, for it was she who pointed it to me. Good job
> someone (Debra) is on the ball <g>
[quoted text clipped - 19 lines]
> >
> > Gord Dibben MS Excel MVP

Reply to this Message

Rate this thread: