Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-29-2018, 11:57 AM
gohn gohn is offline conditional formatting, icon sets Windows 10 conditional formatting, icon sets Office 2013
Novice
conditional formatting, icon sets
 
Join Date: May 2018
Posts: 2
gohn is on a distinguished road
Default 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!
Attached Images
File Type: png result.png (21.7 KB, 24 views)
Reply With Quote
 

Tags
conditional formatting, icon sets



Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting, icon sets Conditional formatting bbutl027 Excel 15 12-05-2016 08:56 PM
conditional formatting, icon sets 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
conditional formatting, icon sets 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, icon sets 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft