Condition format with ICON SET

[rr1050]

Dear's,

I have attached file with explanation of my condition formatting with Icon Set.
Pls guide.

Regards,

Condition format with ICON SET.xlsx



RL

[newdoverman]

The requirements are very vague so I chose Numbers for the traffic lights Green is Greater than or equal to 60, Yellow is greater or equal to 40.

[rr1050]

This is fix value and I know about this, but I required from cell value of actual to plan comparison.
Your thoughts not help me.

Pls advise if you can alternate method.

[newdoverman]

In your example, enter beside each cell what you would expect to see and why. Right now, what you have set up are absolute references to D3 and that obviously isn't giving you what you want.

[rr1050]

in Formula only accept = $D$3
To apply each row condition format separate is time consuming.
I think you do not get solution, but thanks for trying.

[newdoverman]

Without clarification of your problem showing exactly what you expect, there is little chance of finding a solution. Unfortunately, your example doesn't show what you expect and why you expect it.

Thank you for the feedback.

[rr1050]

My file and explanation really self explanatory & easy. Excel condition formatting need to be improved.

Any other please can help me?