4 Replies Latest reply on Dec 12, 2016 8:35 PM by Mahfooj Khan

    Conditional Formatting of color based on a numerical value?

    Justin Doster

      I want to use the "packed bubbles" chart as a heatmap.  I have an excel worksheet that creates a numerical score for a series of data based on a weighted average scoring system.  The result is a numerical score between 0-10.  I want the bubbles on the chart to be red for items that score 7-10, yellow for 4-6, green for 1-3 and grey for 0.  How would I be able to do that?  So a basic example of the data would be:

       

         

      vdisk_namecapacityTotal
      ITGC2ESXPROD_1_500GB5009
      itgcurs210_1342_512Gb5129
      ITGC2ESXPROD_24_1024GB10247
      itgcurs210_1343_512Gb5129
      itgcurs278_1199_50GB502
      itgcurs157_1035_40GB404
      itgcurs321_1636_70GB702
      itgcurs59_156_100GB1002
      itgcursj0512_967_50GB502
      itgcurs150_1497_15GB154
      itgcurs183_1519_15GB152
      itgcurs211_778_275GB2754
      itgcurs310_1171_50GB502
      itgcurs203_715_25GB256
      ITGC2TDQ1ESXC_50_1024GB10240
      itgcurs210_1311_10Gb106
      itgcursj0513_969_50GB502

       

       

      Any ideas?  Thank you in advance.

       

      Justin Doster