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
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.
So you colour code these 2 separate columns in Format Rules on in the Doc itself?
Correct. If the value is like FALSE, it won’t show anyting with the IFS expression.
User | Count |
---|---|
18 | |
10 | |
8 | |
6 | |
5 |