| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
traffic light based on 3 different conditions
Question;
I want conditional formatting on cel A1. Red when A1 < B1 AND <C1 Orange when A1 < B1 AND C1 Green when A1 B1 AND C1 I can make the 3 different colours but I cannot get the formula working. My formula (for RED): =AND($A1<$B1,$A1<$C1) Using MS Excel 2003 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
traffic light based on 3 different conditions
in Conditional Formatting click Add to add new conditions if the RED
is set formula for Orange: =AND(A1<B1,A1C1) then click Add again formula for Green: =AND(A1B1,A1<C1) OK On 14 Sty, 13:55, wrote: Question; I want conditional formatting on cel A1. Red when A1 < B1 AND <C1 Orange when A1 < B1 AND C1 Green when A1 B1 *AND C1 I can make the 3 different colours but I cannot get the formula working. My formula (for RED): =AND($A1<$B1,$A1<$C1) Using MS Excel 2003 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
traffic light based on 3 different conditions
On 14 jan, 14:00, Jarek Kujawa wrote:
in Conditional Formatting click Add to add new conditions if the RED is set formula for Orange: =AND(A1<B1,A1C1) then click Add again formula for Green: =AND(A1B1,A1<C1) OK On 14 Sty, 13:55, wrote: Question; I want conditional formatting on cel A1. Red when A1 < B1 AND <C1 Orange when A1 < B1 AND C1 Green when A1 B1 *AND C1 I can make the 3 different colours but I cannot get the formula working. My formula (for RED): =AND($A1<$B1,$A1<$C1) Using MS Excel 2003- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - That part works. Unfortunately the formula does not work. Do you maybe know if there is an error in the formula? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
traffic light based on 3 different conditions
what do you mean by "Unfortunately the formula does not work"?
IMHO there shouldn't be a formula =AND($A1<$B1,$A1<$C1) in A1, just another formula or value On 14 Sty, 14:36, wrote: On 14 jan, 14:00, Jarek Kujawa wrote: in Conditional Formatting click Add to add new conditions if the RED is set formula for Orange: =AND(A1<B1,A1C1) then click Add again formula for Green: =AND(A1B1,A1<C1) OK On 14 Sty, 13:55, wrote: Question; I want conditional formatting on cel A1. Red when A1 < B1 AND <C1 Orange when A1 < B1 AND C1 Green when A1 B1 *AND C1 I can make the 3 different colours but I cannot get the formula working. My formula (for RED): =AND($A1<$B1,$A1<$C1) Using MS Excel 2003- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - That part works. Unfortunately the formula does not work. Do you maybe know if there is an error in the formula?- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
traffic light based on 3 different conditions
On 15 jan, 08:31, Jarek Kujawa wrote:
what do you mean by "Unfortunately the formula does not work"? IMHO there shouldn't be a formula =AND($A1<$B1,$A1<$C1) in A1, just another formula or value On 14 Sty, 14:36, wrote: On 14 jan, 14:00, Jarek Kujawa wrote: in Conditional Formatting click Add to add new conditions if the RED is set formula for Orange: =AND(A1<B1,A1C1) then click Add again formula for Green: =AND(A1B1,A1<C1) OK On 14 Sty, 13:55, wrote: Question; I want conditional formatting on cel A1. Red when A1 < B1 AND <C1 Orange when A1 < B1 AND C1 Green when A1 B1 *AND C1 I can make the 3 different colours but I cannot get the formula working. My formula (for RED): =AND($A1<$B1,$A1<$C1) Using MS Excel 2003- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - That part works. Unfortunately the formula does not work. Do you maybe know if there is an error in the formula?- Ukryj cytowany tekst - - Pokaż cytowany tekst -- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - This is my formula for GREEN. =AND($A76$D76,$A76$G76) I get an error report which highlights $D76,$A76 Which probably indicates there is an error in the comma. In the cels A,D and G 76 are only values. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
traffic light based on 3 different conditions
On 15 jan, 10:03, wrote:
On 15 jan, 08:31, Jarek Kujawa wrote: what do you mean by "Unfortunately the formula does not work"? IMHO there shouldn't be a formula =AND($A1<$B1,$A1<$C1) in A1, just another formula or value On 14 Sty, 14:36, wrote: On 14 jan, 14:00, Jarek Kujawa wrote: in Conditional Formatting click Add to add new conditions if the RED is set formula for Orange: =AND(A1<B1,A1C1) then click Add again formula for Green: =AND(A1B1,A1<C1) OK On 14 Sty, 13:55, wrote: Question; I want conditional formatting on cel A1. Red when A1 < B1 AND <C1 Orange when A1 < B1 AND C1 Green when A1 B1 *AND C1 I can make the 3 different colours but I cannot get the formula working. My formula (for RED): =AND($A1<$B1,$A1<$C1) Using MS Excel 2003- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - That part works. Unfortunately the formula does not work. Do you maybe know if there is an error in the formula?- Ukryj cytowany tekst - - Pokaż cytowany tekst -- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - This is my formula for GREEN. =AND($A76$D76,$A76$G76) I get an error report which highlights $D76,$A76 Which probably indicates there is an error in the comma. In the cels A,D and G 76 are only values.- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - Changing the , to a ; made the difference. Now it works. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
traffic light based on 3 different conditions
Yes, you always need to know what your Windows regional settings have
specified as a list separator. -- David Biddulph wrote in message ... Changing the , to a ; made the difference. Now it works. On 15 jan, 10:03, wrote: This is my formula for GREEN. =AND($A76$D76,$A76$G76) I get an error report which highlights $D76,$A76 Which probably indicates there is an error in the comma. In the cels A,D and G 76 are only values |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| traffic light in excel | Excel Discussion (Misc queries) | |||
| How to replace the background color of all cells from light green to light blue? | Excel Discussion (Misc queries) | |||
| I neen a chart background to represent traffic light colors... | Charts and Charting in Excel | |||
| Traffic light problem | Charts and Charting in Excel | |||
| Traffic Light Filter On Dates | Excel Discussion (Misc queries) | |||
Linear Mode
