#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formatting

My Excel only displays Cell Formatting in the Print Preview page, but not
when working in Normal display. Can't see if this is an error in the
programme or whether I've amended the settings somehow. recently had a full
system crash and had to reload my OS, drivers and applications so not sure if
this is the root problem
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default Formatting

Hi,
check if your spreadsheet is protected

"Jim Fleming" wrote:

My Excel only displays Cell Formatting in the Print Preview page, but not
when working in Normal display. Can't see if this is an error in the
programme or whether I've amended the settings somehow. recently had a full
system crash and had to reload my OS, drivers and applications so not sure if
this is the root problem

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Formatting

Thanks but not protected and still the same - but appreciate the response

"Eduardo" wrote:

Hi,
check if your spreadsheet is protected

"Jim Fleming" wrote:

My Excel only displays Cell Formatting in the Print Preview page, but not
when working in Normal display. Can't see if this is an error in the
programme or whether I've amended the settings somehow. recently had a full
system crash and had to reload my OS, drivers and applications so not sure if
this is the root problem

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Formatting

If by formatting you mean background or fonts colors...............

Check this out................

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

As directed, change the High Contrast setting in Windows OS


Gord Dibben MS Excel MVP

On Thu, 24 Sep 2009 03:50:01 -0700, Jim Fleming <Jim
wrote:

My Excel only displays Cell Formatting in the Print Preview page, but not
when working in Normal display. Can't see if this is an error in the
programme or whether I've amended the settings somehow. recently had a full
system crash and had to reload my OS, drivers and applications so not sure if
this is the root problem


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Formatting

Gord
Thank you - this fixed this straight away !

Really appreciated you taking the time out to give me the answer

"Gord Dibben" wrote:

If by formatting you mean background or fonts colors...............

Check this out................

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

As directed, change the High Contrast setting in Windows OS


Gord Dibben MS Excel MVP

On Thu, 24 Sep 2009 03:50:01 -0700, Jim Fleming <Jim
wrote:

My Excel only displays Cell Formatting in the Print Preview page, but not
when working in Normal display. Can't see if this is an error in the
programme or whether I've amended the settings somehow. recently had a full
system crash and had to reload my OS, drivers and applications so not sure if
this is the root problem



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
condionally formatting based on another cells formatting? Derrick Excel Discussion (Misc queries) 2 July 31st 09 08:05 PM
Conditional formatting--different formatting depending on cell con Tammy S. Excel Discussion (Misc queries) 3 March 30th 09 08:11 PM
Formatting cells in a column with conditional formatting? shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
expanding custom formatting without removing existing cell formatting? Keith Excel Worksheet Functions 3 December 27th 06 01:54 PM


All times are GMT +1. The time now is 04:11 PM.

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

About Us

"It's about Microsoft Excel"