I have a list of Activity Definitions B4:B28 and I have already added a color to each cell. I want that color to transfer to the time log cells Data Validation list on the Activity Sheet. Can that be done? Or do I have to use the conditional formatting and "restate" all of the colors? It seems like it should pull the color from the list of cells I have chosen.
Thank you for any help!
Barbara
Bookmarks