conditional formatting help

Question

Hello community&nbsp;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($D2*0.81)&gt;$D2), but I'm not really sure what I'm doing. I also need to copy this formula down fifteen or more rows. Can anyone help?

sergeibaklan · Answer

Hi Noel,&nbsp;I guess the conditional formatting rule formula could be=$C2&lt;0.8*$D2and the rule is applied to $C$2:$C$17 or to entire column $C:$C&nbsp;

noel · Answer

Sergei,Unfortunately that formula is not working. I tried playing around with the anchors and the formatting doesn't work.

sergeibaklan · Answer

Noel, here and attached&nbsp;

noel · Answer

SergeiWould 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?&nbsp;

sergeibaklan · Answer

Noel, are you sure you have numbers in your columns, not text? Try in any empty cell=ISNUMER(C2)does&nbsp;it return TRUE or FALSE.&nbsp;As for the rules both works, but first rules (from top to down) have priority on next ones.&nbsp;Please check attached file.

Forum Discussion

conditional formatting help

6 Replies