i want to put icon set for a cell on two condtion.
for example my cell for icon set is A2
and i have another cell A3 which contain some value and which i want to use for second condtion on the above cell.
1st condition – if A3 >0 then icon set for A1 will always be red. ( then value of A2 doest not matter).
if A3 < = 0 then it will chek for second condition.
2nd condition – if A2 >=90 it will set green less then 90 it would be red.
the fight is that i have to use only icon Set formatting only.
By: Chandan Mehta