conditional formatting spreadsheet

  • 1
  • Question
  • Updated 4 years ago
  • Answered
  • (Edited)
I'm using a google spreadsheet to display parking conditions. When a
parking is open or closed i put in a cell the word "open" or "closed".

With conditional formatting  the text is green for open and red for closed.

On the presentation using the google spreadsheet widget, i just get black text. Is there a way to display taht text in the desired color?
Photo of Alexander Mattelaer

Posted 4 years ago

  • 1
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Alexander,

In order to pull over custom colors, you will need to use a custom layout for your widget. Documentation can be found here
Ok, thanks, but it seems i will need the customs layout which is still in Beta. When will be the relaese of this?

Or is there a possibility to use in html something like "if text=open, color = green"?
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Alexander,

The documentation is actually incorrect and needs to be updated. The custom layout feature is built into our stable widget.