Forum Discussion
Solved
Conditional Format cell color based on value tied to specific value in dropdown list
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 🙂
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))
1 Reply
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))