Conditional formatting of a Dynamic Dashboard based on 2 variables

Welcome to the forum.

You can do this with Index-Match.
1. Select the range you want the Conditional Formatting to apply to - in the sample file, this is B4:F14.
2. Click Conditional Formatting → New Rule → Use a formula to determine which cells to format.
3. Enter this in the formula box:

Formula:

Please Login or Register  to view this content.

Adjust the C2:C19 and B2:B19 ranges to match your real ranges. The C range is the dangerous yes/no column; the B range is the list of animals. Note that the ranges need to be the same size.
B4 here is the top-left of the range you selected in step 1. Because you pre-selected the range in that step, Excel will automatically apply the rule to the rest of the range, adjusting the cell reference 'behind the scenes.' Note that B4 here is a relative reference (no $ signs) - that's important.
4. Choose the format you want (green fill) and click OK.

Hope that does what you want.

You're welcome, glad I could help and thanks for marking the thread as Solved.