Icon Sets on a different cell based on formulas and/or values on different cells

Hello,

I've attached a sample.

To make the long story short, given the TARGET and ACTUAL on column A and B respectively, if I want to have the icon sets appear on column 'C' without having a formula, is it possible of doing so?

In a sense, I'd like to have the 'formula' to evaluate and then apply the icon sets on column C.

Ohh, there's a small exception. If in the 'ACTUAL' column which is column B is 0% or blank, then instead of icon sets, it'll be a word 'TBD'.

Hi,

When you say "without having a formula", can I clarify whether you require no formula at all in column C or whether you just require no value displayed in column C? If the latter, the attached should help. If the former, you will require some awkward VBA that will give a result similar to what you have attached above.

Hope this helps,

---
Bernieburnham