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 mon...
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))
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))