I have tried every sequence that I know. The painter will not paint columns,
rows, cells. Any suggestions?
David
Don't use Painter.
Highlight the cells you want to colour and then use Format / cells / patterns
HTH
Michael M
> I have tried every sequence that I know. The painter will not paint columns,
> rows, cells. Any suggestions?
SteveW - 22 Jul 2006 11:01 GMT
because Format Painter, is more akin to a paintbrush that you dip into
other cells and then paint new ones.
ie copy/paste
> David
> Don't use Painter.
[quoted text clipped - 9 lines]
>> --
>> davidb

Signature
Steve (3)
I am still having the problem. I thought that I had a formatting issue, yet
on a new sheet, the problem still occurs. I even cleared the sheet first for
hidden formatting, it did not work. It is so strange why it will not allow
me.

Signature
davidb
> I have tried every sequence that I know. The painter will not paint columns,
> rows, cells. Any suggestions?
Ron de Bruin - 22 Jul 2006 13:20 GMT
Maybe
http://www.contextures.com/xlfaqApp.html#Fill

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
>I am still having the problem. I thought that I had a formatting issue, yet
> on a new sheet, the problem still occurs. I even cleared the sheet first for
[quoted text clipped - 3 lines]
>> I have tried every sequence that I know. The painter will not paint columns,
>> rows, cells. Any suggestions?
SteveW - 22 Jul 2006 13:36 GMT
Is this after Michael's advice ?
If it is, reply would have been better placed there.
As its a reply to your own - maybe you haven't read his reply.
> David
> Don't use Painter.
> Highlight the cells you want to colour and then use Format / cells /
> patterns
>HTH
> Michael M
Steve
> I am still having the problem. I thought that I had a formatting issue,
> yet
[quoted text clipped - 3 lines]
> allow
> me.

Signature
Steve (3)
Sorry, this was a general reply to all responces. I just noticed my "no
fill" in the "automatic" is blank. I tried to add color, but it would not
allow me.

Signature
davidb
> I have tried every sequence that I know. The painter will not paint columns,
> rows, cells. Any suggestions?
Michael M - 23 Jul 2006 00:14 GMT
David
This may be a dumb question, but are you actually in Excel and not Word??
Is this an Excel sheet in a word document ??
The "No Fill " and "Automatic" you mentioned are usually found in Word
formatting not Excel.
Regards
Michael M
> Sorry, this was a general reply to all responces. I just noticed my "no
> fill" in the "automatic" is blank. I tried to add color, but it would not
> allow me.
>
> > I have tried every sequence that I know. The painter will not paint columns,
> > rows, cells. Any suggestions?
Davidb - 23 Jul 2006 06:09 GMT
I am in Excel and in fact you can see the color in print preview.

Signature
davidb
> David
> This may be a dumb question, but are you actually in Excel and not Word??
[quoted text clipped - 12 lines]
> > > I have tried every sequence that I know. The painter will not paint columns,
> > > rows, cells. Any suggestions?