How to change row color based on percentage??

Closed
mahall Posts 1 Registration date Thursday October 2, 2014 Status Member Last seen October 2, 2014 - Oct 2, 2014 at 10:45 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 3, 2014 at 01:33 AM
Hello,

Starting in cell "AB10" I have a value in percentage, if the percentage is below 20% I want the entire row to be yellow fill, if below 10% I want yellow fill and red text for row. Please Help.

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 3, 2014 at 01:33 AM
use conditional formatting
0