Forum Discussion
Problem with conditional formatting
I think this is what you want. You're % formulas seemed to be off. I adjusted them.
O3 = =COUNTIFS($D$5:$D$1000,">="&O2)/COUNTA($D$5:$D$1000)
S3 = =COUNTIFS($D$5:$D$1000,"="&S2)/COUNTA($D$5:$D$1000)
For the conditional formatting you need to use the "~" character. "?" is a reserved wildcard character.
Hi i made the adjustments however the percentages still wont adjust correctly i think its because O3-
R3 is the 100% leaving the S3 adjusting a percentage all by itself. Under conditional formatting when I make the corrections using the ~ instead of ? the poles that fall under "O3" stay the same color as the R3 poles. Any ideas?
I think this is what you want. You're % formulas seemed to be off. I adjusted them.
Perfect, Thank you exactly what i was trying to do.