The problem I’m having is that the conditional formatting I have set in my Google sheet is not appearing on my site. I know my Google sheet is linked and auto-importing correctly — if I make a text change on Google it is appearing in the table on my site. However, the colouring of my table rows is not showing up.
If I manually change the colour of a row or cell in Google, that change shows up on my site. The problem is that I have a few conditional formats set up (example: if the STATUS is set to “TRAIL UNAVAILABLE” the row background colour changes to light red) and the colours (red, yellow, green) are not appearing.
This is something that I am also interested in. However I would like individual cells to be coloured depending on the contents of the cell e.g. if the cell contains the text “Booked” I would like (as in the original Google Sheet) the cell to be coloured red but if it contains the text “Available” the cell should be coloured green. Is this possible?