Conditional formatting help!

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.

Please help!

 

By: Chandan Mehta

Leave a Reply

Your email address will not be published. Required fields are marked *