Hi
Is there a way to colour code a template based on entries made in the survey form.
For example
if Acceptable, the template cell would turn green in the pdf
If Unacceptable, the template cell turn red in the pdf
I would need this for 20+ cells, so the easier it is to do the better!
Thank you in advance!
Hi,
If you are using google Sheets or Excel template, try to use โConditional Formatโ function within Google sheets or Excel.
I knew โConditional Formatโ allows us to change cell colors by some condition, e.g. โwhen the value is agree, change background to greenโ. Not quite sure if AppSheet support that or not.
Letโs have a try.
You canโt format the background, but you can format the color of the text font if itโs suffice.
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |