| 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 |
| 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) | |||
Threaded Mode
