Forum Discussion
conditional formatting help
Hello community I'm trying to create and copy a formula to the selected cell in column C red if that cell value is 80% or lower than the cell next to it in column D. I tried this formula (=SUM($D...
Hi Noel,
I guess the conditional formatting rule formula could be
=$C2<0.8*$D2
and the rule is applied to $C$2:$C$17 or to entire column $C:$C
Sergei,
Unfortunately that formula is not working. I tried playing around with the anchors and the formatting doesn't work.
Noel, here and attached
Sergei
Would it not be working because of the second formula? I didn't think they would impact each other. What else do you think I could be missing?
