Colour coding a template form


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!

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.

1 Like