Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi:
I know that Excel 2003 only allows a Max of 3 conditional formats. I am wondering if there is a formula that can better address my needs. I have 6 different groups of words that I want to trigger 3 different colors depending on what is selected: Approved- A (green) Approved- B (green) Approved- C (green) Rejected- A (red) Rejected- B (red) Dropped (grey) I am using the 'Cell Value is =' selection to do this. Is there a way to solve this with a formula? Is it possible to do this? Thank you, JR |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Yes. Use 3 'Formula Is' conditions. For the Green condition, set Formula Is
to this: =OR(A1="Approved - A", A1="Approved - B", A1="Approved - C") For the Red condition, set Formula Is to this: =OR(A1="Rejected - A", A1="Rejected - B") For the Grey condition, set Formula Is to this: =(A1="Dropped") In this example, A1 is the first cell with the text to be evaluated. You can put the conditional formatting on A1 itself, or on another cell based on what is in A1. You can use Format Painter to copy the conditional formatting to other cells. Hope this helps, Hutch "Roady" wrote: Hi: I know that Excel 2003 only allows a Max of 3 conditional formats. I am wondering if there is a formula that can better address my needs. I have 6 different groups of words that I want to trigger 3 different colors depending on what is selected: Approved- A (green) Approved- B (green) Approved- C (green) Rejected- A (red) Rejected- B (red) Dropped (grey) I am using the 'Cell Value is =' selection to do this. Is there a way to solve this with a formula? Is it possible to do this? Thank you, JR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |