Hi, I want to produce a document with highlighted cell colours depending on the value in the cell (eg, a risk table, showing green/yellow/red) and am hitting problems because Google Docs doesn't support conditional table cell backgrounds. Appsheet can only work from a non-macro-containing Word doc as email template apparently.
I can do this within the Google sheet, but that presents other issues. I can send the data to Excel, but only to a non-macro enabled sheet on 365 online, so I can't a put a button in that to launch a templated word doc with the data. (MS Word does support conditional table cell colors via VBA.)
I guess I can point my user to the relevant folder in 365 and ask them to download the sheet, or even automate that download, but this seems clunky.
Has anyone else solved this issue please?
Many thanks
James
LinkedIn
Twitter
