|I would use a checkbox. Is there any reason you have to have color?|
You could do an if-checked and color the background of the checkbox. You could execute via a button or macro to update or create a final show list.
You might even want to create an if statement to copy and sort to other sheets for show and no-show.
:) Go Wild. LOL