Conditional Formatting not works on Text box

[juan96]

Hello

First refer attached file for reference. I put the =Sum() function to text0 box and put the just number to text1 box.

I hope to make text0 box like text1 box but didn't work.

I searched for solving this issue for several hours but still didn't find.
any mistakes on this ??

 

[cford31]

I had the same problem. When using Sum() it looks like the Databar doesn't show. However, I was able to come up with a work around. Hide the "text0" control and create another control "text0_databar" with control source set to "=text0". Now the data bar shows properly.

 

[Minty]

The sum() is performed after the conditional formatting has been applied. By forcing it into another field first the evaluation happens in a different order.