Combining Value and Goal in KPIs

[kramaswamy]

Hi all,

KPIs are displayed as follows in Excel:

Is there any way to combine the "Value" and "Status" indicators together? I would like to basically have the cell be highlighted based off the status colour. I know that I can manually set the colours of the cells based off of formulas, but I would like to know if I can have it be automatic based off of the KPI status?

[lbendlin]

Did you mean to post this in the Excel forum?