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 |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |