| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - 3 traffic lights
I'm attempting to format using the 3 traffic lights but seem to have an error
using a negative number as a percentage. Here is what I am looking to do: For cells = 0%, green traffic light For cells <0% but = -5%, yellow traffic light For cells <-5%, red traffic light Any help is greatly appreciated. Thanks! James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 conditional formating using 3 traffic lights on percent | Excel Discussion (Misc queries) | |||
| change icon color traffic lights in conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting using 3 Traffic Lights Formula | Excel Worksheet Functions | |||
| set conditional traffic lights depending on adjacent cell value | Excel Discussion (Misc queries) | |||
| How do I use traffic lights in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
