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
1864
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 reply

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