ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Unable to add color to work sheet. (https://www.excelbanter.com/new-users-excel/100715-unable-add-color-work-sheet.html)

Davidb

Unable to add color to work sheet.
 
I have tried every sequence that I know. The painter will not paint columns,
rows, cells. Any suggestions?
--
davidb

Michael M

Unable to add color to work sheet.
 
David
Don't use Painter.
Highlight the cells you want to colour and then use Format / cells / patterns

HTH
Michael M

"Davidb" wrote:

I have tried every sequence that I know. The painter will not paint columns,
rows, cells. Any suggestions?
--
davidb


SteveW

Unable to add color to work sheet.
 
because Format Painter, is more akin to a paintbrush that you dip into
other cells and then paint new ones.

ie copy/paste


On Sat, 22 Jul 2006 08:56:01 +0100, Michael M
wrote:

David
Don't use Painter.
Highlight the cells you want to colour and then use Format / cells /
patterns

HTH
Michael M

"Davidb" wrote:

I have tried every sequence that I know. The painter will not paint
columns,
rows, cells. Any suggestions?
--
davidb




--
Steve (3)

Davidb

Unable to add color to work sheet.
 
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.
--
davidb


"Davidb" wrote:

I have tried every sequence that I know. The painter will not paint columns,
rows, cells. Any suggestions?
--
davidb


Ron de Bruin

Unable to add color to work sheet.
 
Maybe
http://www.contextures.com/xlfaqApp.html#Fill


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Davidb" wrote in message ...
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.
--
davidb


"Davidb" wrote:

I have tried every sequence that I know. The painter will not paint columns,
rows, cells. Any suggestions?
--
davidb




SteveW

Unable to add color to work sheet.
 
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

On Sat, 22 Jul 2006 13:16:01 +0100, Davidb wrote:

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.




--
Steve (3)

Davidb

Unable to add color to work sheet.
 
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.
--
davidb


"Davidb" wrote:

I have tried every sequence that I know. The painter will not paint columns,
rows, cells. Any suggestions?
--
davidb


Michael M

Unable to add color to work sheet.
 
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

"Davidb" wrote:

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


"Davidb" wrote:

I have tried every sequence that I know. The painter will not paint columns,
rows, cells. Any suggestions?
--
davidb


Davidb

Unable to add color to work sheet.
 
I am in Excel and in fact you can see the color in print preview.
--
davidb


"Michael M" wrote:

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

"Davidb" wrote:

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


"Davidb" wrote:

I have tried every sequence that I know. The painter will not paint columns,
rows, cells. Any suggestions?
--
davidb



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com