Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JA
 
Posts: n/a
Default Color Fill for a cell does not appear on Excel screen

After selecting a cell and hitting the color fill button, the cell is not
filled. However, I can print the table and the fill appears correctly. I'm
reduced to putting an "X" in a cell as opposed to filling it in.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Color Fill for a cell does not appear on Excel screen

Hi, try to look if doesn't have a conditional format on that cell...

hope this helps
Marcelo

"JA" escreveu:

After selecting a cell and hitting the color fill button, the cell is not
filled. However, I can print the table and the fill appears correctly. I'm
reduced to putting an "X" in a cell as opposed to filling it in.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JA
 
Posts: n/a
Default Color Fill for a cell does not appear on Excel screen

Marcelo,

Thank you for the response. The problem exists on the entire page -- all
cells. Opening a new spreadsheet does not help in that when I fill (hit the
bucket icon) the cell or cells do not fill. A print preview and print will
display the filled in cells. I checked an could not see that I had a
conditional format in effect. (I do truly appreciate your response. I've
been attacking this on and off for three days!)

"Marcelo" wrote:

Hi, try to look if doesn't have a conditional format on that cell...

hope this helps
Marcelo

"JA" escreveu:

After selecting a cell and hitting the color fill button, the cell is not
filled. However, I can print the table and the fill appears correctly. I'm
reduced to putting an "X" in a cell as opposed to filling it in.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Color Fill for a cell does not appear on Excel screen

Sorry JA, I am not sure if I understand exact what is hapen in your
spreadsheet.

Couldn't you see the information on the screen, but you see on the print
preview?

it the answer is yes, try to selected all cells and go to FORMAT |
CONDITIONAL FORMAT | EXCLUDE and selecte the 3 conditions, also format the
range color and the text color as automatic.

hope this helps
Regards from Brazil
Marcelo

"JA" escreveu:

Marcelo,

Thank you for the response. The problem exists on the entire page -- all
cells. Opening a new spreadsheet does not help in that when I fill (hit the
bucket icon) the cell or cells do not fill. A print preview and print will
display the filled in cells. I checked an could not see that I had a
conditional format in effect. (I do truly appreciate your response. I've
been attacking this on and off for three days!)

"Marcelo" wrote:

Hi, try to look if doesn't have a conditional format on that cell...

hope this helps
Marcelo

"JA" escreveu:

After selecting a cell and hitting the color fill button, the cell is not
filled. However, I can print the table and the fill appears correctly. I'm
reduced to putting an "X" in a cell as opposed to filling it in.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Color Fill for a cell does not appear on Excel screen

Check this article


http://support.microsoft.com/default.aspx?kbid=320531
Changes to fill color and fill pattern are not displayed in Office programs

--
HTH

Bob Phillips

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

"JA" wrote in message
...
Marcelo,

Thank you for the response. The problem exists on the entire page -- all
cells. Opening a new spreadsheet does not help in that when I fill (hit

the
bucket icon) the cell or cells do not fill. A print preview and print

will
display the filled in cells. I checked an could not see that I had a
conditional format in effect. (I do truly appreciate your response. I've
been attacking this on and off for three days!)

"Marcelo" wrote:

Hi, try to look if doesn't have a conditional format on that cell...

hope this helps
Marcelo

"JA" escreveu:

After selecting a cell and hitting the color fill button, the cell is

not
filled. However, I can print the table and the fill appears

correctly. I'm
reduced to putting an "X" in a cell as opposed to filling it in.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Changing Cell Reference's when Pasting in Excel No I'm Spartacus Excel Discussion (Misc queries) 0 February 13th 06 01:01 PM
I want to use a formula in excel to highlight a cell 30 days prio MWad22368 Excel Worksheet Functions 1 February 13th 06 02:51 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"