Change Color for InputFields

[Anonymous]

I have a "What If" column in a pivot that I'd like to make the data and/or background color change if the user changes the default data loaded in that column. Anyone know how to do this?

[disqr_rm]

Can you load same data into another field and then compare to set color of the cell? Would that work for you?

Otherwise, please attache a simple sample document here.

[Anonymous]

Thanks Rakesh, but I figured it out.

[disqr_rm]

Could you please share your solution with the community? Thank you.

[Anonymous · Accepted solution]

In the load script I preload the input field with the same values as the original column, then in the pivot chart I just check to see if the value is different. I put the following in the Text Color property of the Expression holding the input field:

if

(column(10)<>column(9),rgb(0,0,255))