Hello,
I'm creating a scorecard for sales and would like to use conditional formatting to visually enhance. For each percentage score reached, an if statement creates a comment ("premium", needs improvement" etc) each of the 5 possible comments has a number 1-5 associated with it. In A77 a Vlookup formula takes the statement from B76 and assigins the 1-5 value. I would like to use numbers 1-5 to create the a three color cond format that uses the min-midpoint-max gradient to shade the statement in B76. Have tried formula entries etc but not working. Any possibility to do this?
thanks in advance, Bill
I'm creating a scorecard for sales and would like to use conditional formatting to visually enhance. For each percentage score reached, an if statement creates a comment ("premium", needs improvement" etc) each of the 5 possible comments has a number 1-5 associated with it. In A77 a Vlookup formula takes the statement from B76 and assigins the 1-5 value. I would like to use numbers 1-5 to create the a three color cond format that uses the min-midpoint-max gradient to shade the statement in B76. Have tried formula entries etc but not working. Any possibility to do this?
thanks in advance, Bill