Fuctions

Hello Catherine,

Thank you for your post. For the first part of your question, select the cell(s) containing the drop-downs. In the Home tab, select Conditional Formatting. Select Highlight Cells Rules, then select Text that Contains. In the box, type in the first drop-down option, then click the drop-down where you set the formatting. You could either use the quick red, yellow or green options, or select Custom Format for more options.

Because there is more than one item in your in-cell drop-down, you need to create a separate rule for each item.

As for the numbers, you would follow a similar process. Select the cells showing the numbers, then go to Conditional Formatting, Highlight Cells Rules, Equal To. Here you create five rules, one for each possible value (1 to 5). Again, for each rule, set the relevant colour.

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer