Is it possible to change the colour of parts ...

(Simon Robinson) #1

Is it possible to change the colour of parts of the text in a Google Docs workflow template, depending on an equation?

So if [Column]=TRUE then text in black otherwise in red

(Aleksi Alkio) #2

It’s possible with a trick… <<IFS([Column]=TRUE,[Column])>><<IFS([Column]=FALSE,[Column])>> and if you use different color for these two formulas, it will do that.

(Simon Robinson) #3

So you colour code these 2 separate columns in Format Rules on in the Doc itself?

(Aleksi Alkio) #4

Correct. If the value is like FALSE, it won’t show anyting with the IFS expression.