Is there a possible way to create a list in a single cell like with a data validation of a range of cells that allows you to select multiple selections to fit into the cell at the same time? For instance if i want to click on cells in column "C" they will have the selection available "blue, green, red, yellow" some cells in the column I may only want 1 of these options but in other cells I may want to choose 2 or more options to be inside the cell at the same t

You need some VBA for that - see http://www.contextures.com/excel-data-validation-multiple.html