You are finished with only one item within list. Select the cell within the list to which you wish to apply the formatting.įormula should look something like: ='Workbook Data'!$A$2ħ) Click the formula icon again to return to format menu.Ĩ) Click on Format button beside preview pane. The formula bar (far right), select which worksheet the validation list was created in, ( Have the worksheet open to where the drop down was created)Ģ) Select which answer to apply format to.ģ) Click on 'Home' tab, then click the 'Styles' tool button on the ribbon.Ĥ) Click 'Conditional Formatting', in drop down list click the '*New Rule' option.ĥ) Select a Rule Type: 'Format only cells that contain'Ħ) Edit the Rule Description: 'Cell Value', 'equal to', click the cell formula icon in The following steps must be completed for each item within the validation list. In Excel 2010 it is easy, just takes a few more steps for each list items. I am really getting frustrated, and would greatly appreciate any assistance to find a solution. The items in the the drop down list in I8 and the corresponding color for cell H8 are Elementary -> Blue The problem is that all the solutions I have found will only allow for a 'Yes/No' or '0/1' selection.

If I select 'Pre-Intermediate' from the drop down list in I8 I would like the fill color of H8 to change to 'Red')

In cell H8 I want to have a fill color based on the selected level from a drop down list in cell I8. The last two cells of each row are the color code for the course and the level of the course. In each row I have data pertaining to times, rooms, and programs. I have a table which shows a weekly class schedule for my teaching. This is my first time here so I hope I'm doing things right.įirst of all, I have been investigating this for quite a while, and have found many useful tips for manipulating cell colors in Excel, but none have been able to accomplish the task.

Tools menu in excel 2016 mac