Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do i get more then 3 colours conditions in one sheet in excel

Hello , i am new excel user (excuse me for that...)
I am trying to have more than 3 colors conditions in one data sheet
The idea to give every group one colors , and i have many groups...
I have one basic sheet , that takes all data from many other sheets in same
file
on the rows and columns , but the information is different for each group
some of the groups data is similar but it is not always the case
the major thing is to be able to give to groups and number and letter
different colors
Thank you very much for your help !
Albert
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default How do i get more then 3 colours conditions in one sheet in excel

VBA, or Excel 2007.

In Excel 2003, Conditional Formatting is limited to 3 conditions (plus
whatever format you set as the baseline when none of the conditions are
satisfied).
--
David Biddulph

"albertfirst" wrote in message
...
Hello , i am new excel user (excuse me for that...)
I am trying to have more than 3 colors conditions in one data sheet
The idea to give every group one colors , and i have many groups...
I have one basic sheet , that takes all data from many other sheets in
same
file
on the rows and columns , but the information is different for each group
some of the groups data is similar but it is not always the case
the major thing is to be able to give to groups and number and letter
different colors
Thank you very much for your help !
Albert



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
how do I change existing colours on a sheet? richarf Excel Discussion (Misc queries) 0 August 27th 07 11:42 AM
How to add comments/colours to cells in a protected sheet Nousj Excel Discussion (Misc queries) 2 June 21st 06 01:58 PM
Changing colours by conditions duncan79 Excel Discussion (Misc queries) 3 May 17th 06 08:26 PM
Excel 2003 font colours and cell colours bretta Excel Discussion (Misc queries) 1 April 17th 05 03:45 AM
How can I show sheet names in different colours dabblerdave New Users to Excel 2 December 2nd 04 03:49 PM


All times are GMT +1. The time now is 07:57 PM.

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"