Hi,
I am trying to have a cell show an icon set based on another cells value. The other cell being a percentage value. I have it working... almost. It turns out that the cell I am placing the icon set in is a Unit Price cell (column) which is looking at a cell elsewhere in the workbook. When the Unit Price cell is empty (no value) the conditional logic works as I would like. In this case if the percentage cell is 100%, the Unit Price cell shows a green circle at the left. If the percentage cell is anything less than 100% and not 0 then the icon is yellow. 0 percent gets a red icon. However if the Unit Cost cell gets a value itself, the icon is always green. It appears to be ignoring the percentage cell value. I based the conditional logic on an equation with the Type field set to Number. The equations are as follows. Green icon when value is >= =If($G$4>.99;0;1) and Red when < formula >= =If(($G$4=0;0;.1).
Why does the Unit Cell ignore the conditional logic once a value is entered in that cell?
I am trying to have a cell show an icon set based on another cells value. The other cell being a percentage value. I have it working... almost. It turns out that the cell I am placing the icon set in is a Unit Price cell (column) which is looking at a cell elsewhere in the workbook. When the Unit Price cell is empty (no value) the conditional logic works as I would like. In this case if the percentage cell is 100%, the Unit Price cell shows a green circle at the left. If the percentage cell is anything less than 100% and not 0 then the icon is yellow. 0 percent gets a red icon. However if the Unit Cost cell gets a value itself, the icon is always green. It appears to be ignoring the percentage cell value. I based the conditional logic on an equation with the Type field set to Number. The equations are as follows. Green icon when value is >= =If($G$4>.99;0;1) and Red when < formula >= =If(($G$4=0;0;.1).
Why does the Unit Cell ignore the conditional logic once a value is entered in that cell?
Last edited: