Forum Discussion
Solved
Change colour of text in whole row when 1 cell is negative %
Hello I'm wondering if there is a way of changing the colour of text in a whole row when one of the cells is a negative %. I've tried various conditional formatting using the <0 but that didn't wor...
Not sure if you can read from the picture that SanthoshKunder uploaded. I can't.
Perhaps this one will help you on your way.
Range A1 to I17 contain percentages, but that doesn't really matter. The CF formula is as follows:
=SUM(--($A1:$I1<0)) applied to =$A$1:$I$17
Not sure if you can read from the picture that SanthoshKunder uploaded. I can't.
Perhaps this one will help you on your way.
Range A1 to I17 contain percentages, but that doesn't really matter. The CF formula is as follows:
=SUM(--($A1:$I1<0)) applied to =$A$1:$I$17
Riny_van_Eekelen thanks so much. Yes, that has worked