Forum Discussion

sampak88's avatar
sampak88
Copper Contributor
Mar 02, 2022
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%    ...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Mar 02, 2022

    sampak88 

    =((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?

sampak88's avatar
sampak88
Copper Contributor
Mar 02, 2022
ok, worked it out. thanks!

Resources