Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default colours in spread sheets

I am trying to set up a spread sheet but i want to use colours to aid this
ie: 75%+green 50%-74% amber 49% - red can you tell me how to put this into
action
Regards Andie
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default colours in spread sheets

Check out help on Conditional Formatting and Icon Sets(if using 2007)


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 14:59:01 -0700, Llanelli lad <Llanelli
wrote:

I am trying to set up a spread sheet but i want to use colours to aid this
ie: 75%+green 50%-74% amber 49% - red can you tell me how to put this into
action
Regards Andie


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default colours in spread sheets

Conditional Formatting
--
David Biddulph

Llanelli lad wrote:
I am trying to set up a spread sheet but i want to use colours to aid
this ie: 75%+green 50%-74% amber 49% - red can you tell me how to
put this into action
Regards Andie



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
Cleaning up spread sheets Jan Excel Worksheet Functions 1 September 20th 08 04:01 PM
Combining two spread sheets DavidK Excel Discussion (Misc queries) 0 March 8th 07 07:52 PM
spread sheets - adding UCHA Excel Worksheet Functions 3 August 29th 06 07:38 PM
Charts from Spread sheets nick g Excel Discussion (Misc queries) 3 July 27th 05 05:01 PM
Merging two spread sheets ronski1 Excel Worksheet Functions 1 March 2nd 05 03:27 PM


All times are GMT +1. The time now is 08:10 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"