I have list of 61 text items in a column on a spread sheet called Data

In another sheet, Week 7, I have set up multiple cells to populate from the list by data validation (all working fine)

These 61 text items will have 1 of 6 colors associated with them selected from the drop down list.

I have successfully setup Conditional Formatting with 6 different colors, using New Formatting Rules>Classic>Format only cells that contain>Specific text>containing> & this is where my problem is ... I've only been able to put in the text from one cell Not multiple Cells, ie

From spread sheet "Data" in cell D2 is the text Billable & in D3 is the text Partially Billable. If either of these are selected from drop down on sheet titled "Week 7" I want them to color blue but I see no way of selecting the text from more than one cell.

So I could make 61 Conditional Formatting Rules for each item in the list but that seems like a lot of work

Am I using the wrong drop down selection in the Conditional Formatting - New Formatting Rule dialog box? Should it be "Use a formula to determine which cells to format" instead?