Hello Dear,
I have used Icon Sets of Conditional Formatting for this range based on the criteria shown in the attached 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) or (value - MIN()/(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!
Thanks.
https://myjohnsimon1.tumblr.com/image/176946459865
https://myjohnsimon1.tumblr.com/image/176946580625
I have used Icon Sets of Conditional Formatting for this range based on the criteria shown in the attached 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) or (value - MIN()/(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!
Thanks.
https://myjohnsimon1.tumblr.com/image/176946459865
https://myjohnsimon1.tumblr.com/image/176946580625
Last edited by a moderator: