Forum Discussion
Solved
Dynamic Conditional Formatting
I have a table where there are multiple rows: Question OveralRate Male Female PNTS xyz 44% 45% 55% 30% xyz2 38% 51% 32% ...
=((C2<$B2-3)*(C2>=$B2-6))+((C2>$B2+3)*(C2<=$B2+6))This is the rule for conditional formatting for Overall rate +/- 3 and +/-6 in the attached example file.
=(C2<=$B2+3)*(C2>=$B2-3)This is the rule for conditional formatting for Overall rate +/- 3 in the attached example file.
Is this what you are looking for?
=((C2<$B2-3)*(C2>=$B2-6))+((C2>$B2+3)*(C2<=$B2+6))This is the rule for conditional formatting for Overall rate +/- 3 and +/-6 in the attached example file.
=(C2<=$B2+3)*(C2>=$B2-3)This is the rule for conditional formatting for Overall rate +/- 3 in the attached example file.
Is this what you are looking for?
ok, worked it out. thanks!
You are welcome.