Forum Discussion

Cindy Christie's avatar
Cindy Christie
Copper Contributor
Mar 20, 2018

color coding blank cells based on drop down selection

I am trying to put together an Excel sheet to track which items have been viewed by participants to training. I have created a dropdown list of 4 items (outline1, outline2, etc.). If they select Outline2, I want the corresponding cells color coded that are unique to outline 2. There would be no data in the cells, just the coloring indicating that the item has been viewed. I have NO IDEA how to create the formulas for this. 

 

To make it even more difficult, there are a few items that are found in two outlines (1 and 4 for example). I need some way for the color coding to be inserted (perhaps a two-color combo as a fill selection) if either Outline 1 or Outline 4 is selected from the dropdown. 

 

I am looking for help here. thanks.

 

No RepliesBe the first to reply

Resources