Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
Hi
I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
Hi Sekhar;
It is possible but limmited to three colors by cell. Excell 2007, in theory, makes this unlimmited because they saw the need for that option as it has been getting popular. Your choice is to use what is called "Conditional Format" under the Format menu. Let me know how it goes. Argy "Sekhar" wrote: Hi I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
Hi Sekhar,
Go to Format, conditional formating then you can give upto 3 conditions. Arul "Sekhar" wrote: Hi I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
Thank you Argy & Arul.
Conditional format was useful, but as you said limited to 3. Is it possible t have more than 3, like say 12. Thanks Sekhar "Argy - Arcasoft" wrote: Hi Sekhar; It is possible but limmited to three colors by cell. Excell 2007, in theory, makes this unlimmited because they saw the need for that option as it has been getting popular. Your choice is to use what is called "Conditional Format" under the Format menu. Let me know how it goes. Argy "Sekhar" wrote: Hi I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
Yes, in Excel 2007.
Otherwise, it needs a VBA solution. -- David Biddulph "Sekhar" wrote in message ... Thank you Argy & Arul. Conditional format was useful, but as you said limited to 3. Is it possible t have more than 3, like say 12. Thanks Sekhar "Argy - Arcasoft" wrote: Hi Sekhar; It is possible but limmited to three colors by cell. Excell 2007, in theory, makes this unlimmited because they saw the need for that option as it has been getting popular. Your choice is to use what is called "Conditional Format" under the Format menu. Let me know how it goes. Argy "Sekhar" wrote: Hi I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
Actually speaking Condtional formatting can have only 3 conditions (till
excel 2003), but most pople forget that there is also a default conditon, one you do it yourself for example. you want to color 4 colors red, blue green and yello on diff, conditons, hat you can do is color all the cells , say red, and then put the 3 conditions. so you will have 4 choices. -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "David Biddulph" wrote: Yes, in Excel 2007. Otherwise, it needs a VBA solution. -- David Biddulph "Sekhar" wrote in message ... Thank you Argy & Arul. Conditional format was useful, but as you said limited to 3. Is it possible t have more than 3, like say 12. Thanks Sekhar "Argy - Arcasoft" wrote: Hi Sekhar; It is possible but limmited to three colors by cell. Excell 2007, in theory, makes this unlimmited because they saw the need for that option as it has been getting popular. Your choice is to use what is called "Conditional Format" under the Format menu. Let me know how it goes. Argy "Sekhar" wrote: Hi I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
David;
Very good point. Would you mind sharing how do you improve the number of conditionals using VB under Excel 2003? Thanks. Argy! "David Biddulph" wrote: Yes, in Excel 2007. Otherwise, it needs a VBA solution. -- David Biddulph "Sekhar" wrote in message ... Thank you Argy & Arul. Conditional format was useful, but as you said limited to 3. Is it possible t have more than 3, like say 12. Thanks Sekhar "Argy - Arcasoft" wrote: Hi Sekhar; It is possible but limmited to three colors by cell. Excell 2007, in theory, makes this unlimmited because they saw the need for that option as it has been getting popular. Your choice is to use what is called "Conditional Format" under the Format menu. Let me know how it goes. Argy "Sekhar" wrote: Hi I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
Very good point. Of course, then you need to understand that you are using
the default format as a authomatic format that would work if neither of the three conditions work. Again, very good catch. Argy "Satti Charvak" wrote: Actually speaking Condtional formatting can have only 3 conditions (till excel 2003), but most pople forget that there is also a default conditon, one you do it yourself for example. you want to color 4 colors red, blue green and yello on diff, conditons, hat you can do is color all the cells , say red, and then put the 3 conditions. so you will have 4 choices. -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "David Biddulph" wrote: Yes, in Excel 2007. Otherwise, it needs a VBA solution. -- David Biddulph "Sekhar" wrote in message ... Thank you Argy & Arul. Conditional format was useful, but as you said limited to 3. Is it possible t have more than 3, like say 12. Thanks Sekhar "Argy - Arcasoft" wrote: Hi Sekhar; It is possible but limmited to three colors by cell. Excell 2007, in theory, makes this unlimmited because they saw the need for that option as it has been getting popular. Your choice is to use what is called "Conditional Format" under the Format menu. Let me know how it goes. Argy "Sekhar" wrote: Hi I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to color a cell if it meets specific condition
You'll find a number of answers in the archives of this group.
http://www.xldynamic.com/source/xld.....Download.html is one example. -- David Biddulph "Argy - Arcasoft" wrote in message ... David; Very good point. Would you mind sharing how do you improve the number of conditionals using VB under Excel 2003? Thanks. Argy! "David Biddulph" wrote: Yes, in Excel 2007. Otherwise, it needs a VBA solution. -- David Biddulph "Sekhar" wrote in message ... Thank you Argy & Arul. Conditional format was useful, but as you said limited to 3. Is it possible t have more than 3, like say 12. Thanks Sekhar "Argy - Arcasoft" wrote: Hi Sekhar; It is possible but limmited to three colors by cell. Excell 2007, in theory, makes this unlimmited because they saw the need for that option as it has been getting popular. Your choice is to use what is called "Conditional Format" under the Format menu. Let me know how it goes. Argy "Sekhar" wrote: Hi I have data which is segregated into 5 trypes A,B,C,D & E. If 'A' appears in cell A1, is there a way to color A1 in green,'B' in A1 then in 'yellow' etc. In short I am asking whether we have something like 'color if' function. I am using Office 2003. Thanks in advance. Regds Sekhar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlight the row if meets the condition | Excel Worksheet Functions | |||
sum if (text meets condition) | Excel Discussion (Misc queries) | |||
Repeat cell data for specific condition | Excel Discussion (Misc queries) | |||
Graphing only data that meets a condition | Charts and Charting in Excel | |||
Identify occurence in "array" which meets condition(s) | Excel Discussion (Misc queries) |