Hello-

I am trying to accomplish a few new things in excel - any help would be much appreciated!

1. I Have a validation list and I have enabled the user to enter data that isn't in the list by putting a warning vs. a stop. I would now like to somehow highlight or change the color of the text of the data the user enters. Does anyone know how to do this?

2. I would like to make my validation list multiselect - all values selected in the same cell delimited by a comma

3. I would like to have data entered in one tab populate in another tab.

Thank you