Does anybody knows how to use an object calculus results to set the color? Something similar to using the pivot table expression name into another expression.
For Example:
A TextBox has the formula : =sum(VALUE)
At the Back Color, I have chosen the calculated color and set: if( sum(VALUE) >20, RED(), WHITE())
Is there a way I could use the textbox´s formula directly into the color formula. It would become something like:
if( TEXTBOX.FORMULA >20, RED(), WHITE())
This would help a lot the maintenance of the code as if I make changes to the text formula, it would automatically change the same value for the color.
why don't you use variables. you could store your expression into a variable and úse this one instead of a textbox. Of course you can display the variable in a textbox, too. But maybe my Idea is a little bit to simple
I thought of that. But sometimes managing 20 variables is kind of messy. If it uses the same formula inside the textbox, I would manage them individually.
