stanl
06-06-2012, 02:58 AM
I was just asked to place a number of metrics into quintiles and color_code respective cells/rows based on quintile ranking. I accomplished this by creating hlookups to associate a metric with a quintile (1-5) then wrote conditional formulas for each color code (see attached jpeg).
This took a long time and my general question is: where is this kept? For example, if I wanted to change the fill color for quintile 4 I would have to go in manually and edit each rule. Would be nice to be able to write VBA code to accomplish the same
This took a long time and my general question is: where is this kept? For example, if I wanted to change the fill color for quintile 4 I would have to go in manually and edit each rule. Would be nice to be able to write VBA code to accomplish the same