I have a table showing thumbnail images of properties for rent. My client maintains a spreadsheet showing availability. Red indicates occupied and availability date not known, yellow means occupied, but availability date known. Green means unoccupied and available on a known date.
I would like to use the data in their spreadsheet/form to set the background color on the thumbnails to red, yellow or green and to show the availability date on hover.
What is the best method to use? I would like to use their existing spreadsheet and link to an adobe form to collect the data that is then used to change the styling on the css elements.