Forum Discussion
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 work.
Be glad if someone could help.
Thanks
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
2 Replies
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
