I am currently working on a spreadsheet that will keep track of each issue of each comic book I have in my collection. I was wondering if there was a way to add a dropdown to each cell that would change the color of the cell from green to red or vice versa so that I can easy mark which issues I have and which I am still looking for? Will I need to make a custom function to do this?
Google Sheets dropdown that changes cell color?
google spreadsheets