gymwrecker
Active Member
- Joined
- Apr 24, 2002
- Messages
- 394
- Office Version
- 365
- Platform
- Windows
- MacOS
By default, for 3 icons, Excel calculates the 67th percent and 33th percent. 67th percent = min + 0.67 * (max-min) = 2 + 0.67 * (95-2) = 64.31. 33th percent = min + 0.33 * (max-min) = 2 + 0.33 * (95-2) = 32.69. A green arrow will show for values equal to or greater than 64.31. A yellow arrow will show for values less than 64.31 and equal to or greater than 32.69. A red arrow will show for values less than 32.69. How can I change/format those values to the following:
Green = between 100% and 90%
Amber = between 89% and 80%
Red = anything below 79%
Note: I'm using MS Excel 2013
Green = between 100% and 90%
Amber = between 89% and 80%
Red = anything below 79%
Note: I'm using MS Excel 2013