PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?Sm9obm55NDM0?=
Guest
Posts: n/a
 
      11th Jul 2006
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 With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      11th Jul 2006
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...b;en-ca;320531


Gord Dibben Excel MVP

On Mon, 10 Jul 2006 19:20:01 -0700, Johnny434
<(E-Mail Removed)> wrote:

>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 With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      11th Jul 2006
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.

--
HTH

Bob Phillips

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

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news(E-Mail Removed)...
> 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...b;en-ca;320531
>
>
> Gord Dibben Excel MVP
>
> On Mon, 10 Jul 2006 19:20:01 -0700, Johnny434
> <(E-Mail Removed)> wrote:
>
> >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 With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      11th Jul 2006
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

On Tue, 11 Jul 2006 08:52:45 +0100, "Bob Phillips" <(E-Mail Removed)>
wrote:

>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.


Gord Dibben MS Excel MVP
 
Reply With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      11th Jul 2006
It must have been Debra, for it was she who pointed it to me. Good job
someone (Debra) is on the ball <g>

--
HTH

Bob Phillips

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

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> 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
>
> On Tue, 11 Jul 2006 08:52:45 +0100, "Bob Phillips" <(E-Mail Removed)>
> wrote:
>
> >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.

>
> Gord Dibben MS Excel MVP



 
Reply With Quote
 
=?Utf-8?B?Sm9obm55NDM0?=
Guest
Posts: n/a
 
      12th Jul 2006
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

"Bob Phillips" wrote:

> It must have been Debra, for it was she who pointed it to me. Good job
> someone (Debra) is on the ball <g>
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
> > On Tue, 11 Jul 2006 08:52:45 +0100, "Bob Phillips" <(E-Mail Removed)>
> > wrote:
> >
> > >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.

> >
> > Gord Dibben MS Excel MVP

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - change columns to rows and rows to columns =?Utf-8?B?VHJpc2g=?= Microsoft Excel Misc 0 17th Aug 2007 02:22 AM
RE: Excel 2003 - change columns to rows and rows to columns =?Utf-8?B?SkxhdGhhbQ==?= Microsoft Excel Misc 0 17th Aug 2007 02:05 AM
waht are the cells in excel measured in? rows/columns=different =?Utf-8?B?dmVyeSBjb25mdXNlZCBpbmRpdmlkdWFs?= Microsoft Excel Misc 3 18th Jul 2007 05:58 PM
In Excel, how do I change the rows into columns? =?Utf-8?B?Tm92aWNlIFNTIFVzZXI=?= Microsoft Excel Misc 1 7th Feb 2005 11:13 PM
text conversion in cells and setting color in rows.....(excel 97) Jeremy Smith Microsoft Excel Programming 0 9th Sep 2003 01:25 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:23 AM.