I have a spreadsheet that was given to me. Several cells have down lists (list contains 1,0,-1 as options). If you select 1, a green circle appears in the cell with a checkmark. If you select 0, just the empty circle appears. If you select -1, an orange circle appears with an exclamation point. I'm a little familiar with data validation but can't figure out how this is done.
Solved by X. J. in 21 mins