| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format - 3 traffic lights
Your conditions here look good. Are you possibly attempting to enter them as
a formula? The simpler method is under condition format, change first box to "cell value is" second box to "greater than or equal to", and type 0% Second condition, change second box to "less than" and type -5% third condition, second box "between" and type 0% and -5% Note that you don't have to worry about overlap, because XL cares more about the order of the conditions. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format - 3 traffic lights
This worked! Thank you!
"Luke M" wrote: Your conditions here look good. Are you possibly attempting to enter them as a formula? The simpler method is under condition format, change first box to "cell value is" second box to "greater than or equal to", and type 0% Second condition, change second box to "less than" and type -5% third condition, second box "between" and type 0% and -5% Note that you don't have to worry about overlap, because XL cares more about the order of the conditions. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
