Hi,
I created a conditional formating with Icon Sets and I am referencing a cell in another sheet that contins percentages. This are the two values I have for the Icon Sets:
>= ='YTD VLU'!$B$46
>= =YTD Chg'!$B$46-0.04
When I create this conditional formatting it works perfectly but when I save the document and open it again it shows everything with the green up triangle (which is wrong). If I enter into one of this cells and click enter that conditional format works for all the cells that it is applied, but not for the rest of the conditional formattings!
What should I do?
I created a conditional formating with Icon Sets and I am referencing a cell in another sheet that contins percentages. This are the two values I have for the Icon Sets:
>= ='YTD VLU'!$B$46
>= =YTD Chg'!$B$46-0.04
When I create this conditional formatting it works perfectly but when I save the document and open it again it shows everything with the green up triangle (which is wrong). If I enter into one of this cells and click enter that conditional format works for all the cells that it is applied, but not for the rest of the conditional formattings!
What should I do?