5
votes

Is it possible to highlight a variable depending on its value?

e.g. automatically highlight this variable green:

variable = "acceptable"

but if it changes to:

variable = "unacceptable"

the highlight would change to red.

2

2 Answers

1
votes

I think you need some sort of service to determine the sentiment from the data a variable contains.

For instance, I can easily call :

https://azure.microsoft.com/en-in/services/cognitive-services/text-analytics/

to determine the difference between "acceptable" and "unacceptable". In the link you can actually call the service with both the words and see that in first case, the result returns 98% sentiment while for the other one it returns 2%. You can use this value even generate a smooth range of rgb colors.

0
votes

I don't know if it is possible to get exactly what you want but this might get you close

From the link:

Export your results to an excel object and have that object displayed in your mathcad sheet may be a way.

Also:

What you are looking for could be done in Mathcad 15 (and below) using scripted components - Text boxes. In Prime this feature is missing.

https://community.ptc.com/t5/PTC-Mathcad-Questions/Is-there-a-way-to-add-conditional-formatting/td-p/328451