Forum Discussion
Make Cells green and red for lower or higher %
Is there a way for example: I can do this without doing it manually?
Above 6% i want green
above 3% I want Amber
below 3% I want red
If this makes sense!! help!!
Sazzasmith85 Yes, you need to use conditional formatting (see screenshot below). First highlight the cells you want to apply this rule to then you will have to set 3 rules separately.
