Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

New Cell Styles

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve... - 01 Apr 2007 12:36 GMT
Can anyone enlighten me as to the purpose of the "Good,Bad and Neutral"
formating in Cell Styles and also the "Data and Model" formatting?
Thanks...........
Bernard Liengme - 01 Apr 2007 13:36 GMT
In XL2007, Microsoft has provided some suggest colours schemes that seem to
go together in a theme.
Suppose you have monthly sales; maybe you want to colour good months with
one colour and bad with another.
Date and Model are similar. One can use one colour for cell with formulas
(calculations); another for raw data.

All that is being offered is a palette of colours; it is up to the user to
decide if and when to use them.

best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Can anyone enlighten me as to the purpose of the "Good,Bad and Neutral"
> formating in Cell Styles and also the "Data and Model" formatting?
> Thanks...........
Steve... - 01 Apr 2007 14:02 GMT
Hi Bernard and thanks for the reply.
I sort of guessed it was something along those lines but was surprised
because the feature seems to have such prominence when viewed on a reasonably
high resolution screen and was not a feature in the 2003 version, at least I
don’t think it was.
I am very quickly getting to like this new ‘Ribbon’ system but again this
feature seems prominent on my machine and I have at least a quarter of the
ribbon (Home Ribbon)  showing this feature when the program is expanded full
screen. I just thought it must therefore have a higher importance than I
guess it does.
Thanks again…….
Steve…..

> In XL2007, Microsoft has provided some suggest colours schemes that seem to
> go together in a theme.
[quoted text clipped - 8 lines]
> best wishes
> --
Nick Hodge - 01 Apr 2007 15:33 GMT
Steve

Expanding on Bernard's reply.  The objective of the ribbon was to help
'average' users produce great looking documents, quickly...job done.

For experienced or 'power' users the ribbon is a bit more of a steep curve
as often the last thing in those peoples mind is pretty formatting, (ex
charts), it the right answer and the data.

I agree, some features are given more prominence than they perhaps deserve,
but being a data, not design guy, I'm actually stating to get pretty data
too ;-)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

> Can anyone enlighten me as to the purpose of the "Good,Bad and Neutral"
> formating in Cell Styles and also the "Data and Model" formatting?
> Thanks...........
Steve... - 01 Apr 2007 16:56 GMT
Hi Nick and thanks for your reply…
I think you are absolutely spot on and I could not figure why there was this
prominence to the formatting I referred to and also I did not realise that
the ones in question, “Good, Bad, and Neutral” were just examples bundled as
the default  and presumberly Microsoft’s best guess as to what users might
want to use them for. I was not aware initially that they are fully
customisable. I wondered why they would give prominence to some kind of
format/audit colouring system and thought I was missing something!
As you suggest, we have always focussed on the numbers but as the day has
progressed (the family are out for the day)  I have also produced some more
colourful numbers. Who knows, I may even fire up ‘Publisher’ next !
Thanks again Nick……..

> Steve
>
[quoted text clipped - 12 lines]
> > formating in Cell Styles and also the "Data and Model" formatting?
> > Thanks...........

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.