I have an application that will allow me to make a “bar chart color” the same color of a cell even if that cell is a conditional formed one.
I have spent a lot of time building this particular application but forgot to take into account that to do the conditional forming the actual numbers NEED to be in the cells. When I first created the file I just forced a “1” into them so the charts are all max 1 min 0.
I find myself now in a situation where in order to make the conditional colors happen the 1’s need to be replaced with the actual %’s which as you KNOW will NOT make my charts work anymore.
Is there a way to FORCE the charts to be always 1??? This really messes up with the % is a negative number as you can imagine. I was thinking of creating a secondary access and forcing it to be 1? I don’t know. Any ideas?????