Hi, Everyone!

I'm working on a seat plan project wherein if button was clicked it'll turn to green if the seat was taken however I can't seem to figure out what to do with the update that I need to do.

Example:
Seat 354 was reported that there was an issue with headset it should turn YELLOW IF someone pressed on the seat 354 (if it was reported previously reported that there was an issue) a Msgbox should also show the issue it has however IF it was tagged as resolved already then the button will turn green again IF pressed.

I would really appreciate if someone will help me out.