#1
|
|||
|
|||
conditional formatting, icon sets
Hello,
I have used Icon Sets of Conditional Formatting for this range based on the criteria shown on below picture, but why 6 is amber while it's 60% and the criterion states >= 60% which should be green, doesn't the 6 equal 60%? (Max=10 and Min=1, 6/10=60%) similarly, while the critera says less than 40 to be red but 40 which is not less than 40 but is red (less than red should be red) and i know Excel calculates it using Min+60%*(max-min) but i don't understand it, yet i assumed it calculates 60% times the total sum of all the data, is it true? so it means >= percent of what? or it's used only for percent values not simple values, or the calculation is based on another method! |
#2
|
||||
|
||||
Are those results rounded numbers?
|
#3
|
||||
|
||||
|
#4
|
|||
|
|||
no, these are simple exact numbers
|
Tags |
conditional formatting, icon sets |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting | bbutl027 | Excel | 15 | 12-05-2016 08:56 PM |
QuickAccess Toolbar Icon - How to make the icon display the state of the icon's action | ElfegoBaca | Word | 1 | 08-13-2016 08:42 PM |
VBA Word - Format ALL Tables - Apply Specific Formatting to Sets of Columns – Font, Border & Width | jc491 | Word VBA | 10 | 11-04-2015 04:02 PM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Formatting imported data into a table with variable record sets | ash6540 | Excel | 6 | 03-27-2014 04:13 AM |