Sep 13 2022 03:22 AM
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!!
Sep 13 2022 03:30 AM
@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.