Conditional Format cell color based on value tied to specific value in dropdown list

[shade206]

Hello,

I looked through a few conditional formatting threads, but did not find my answer. In the sample provided in a second step beyond the indexing i have already done I am trying to tie the month in the drop down list on the sheet labelled "dashboard" with the month and target in the sheet labelled "target" and have the dashboard cells reporting the segments colored Green or Red based on meeting/surpassing or failing to meet the target. 

Please respond in a detailed step by step fashion as I am a visual learner :) 

[#2 · Accepted solution]

@shade206 

You may apply two rules for the range

with formulas

red

=$B2<INDEX(Target!$B$2:$D$13,MATCH($B$1,Target!$A$2:$A$13,0),MATCH($A2,Target!$B$1:$D$1,0))

green

=$B2>INDEX(Target!$B$2:$D$13,MATCH($B$1,Target!$A$2:$A$13,0),MATCH($A2,Target!$B$1:$D$1,0))