Hey, first time on the board.

I have a trouble in where i'm matching data to a specific target which then comes out as a percentage; negative if under (e.g. -75%), 100% if exact or positive if over (e.g. 125%). I've been trying to format it so that 5% either side of 100% is green and anything else is red.

For example:

Actual Target Target %
54,504 47,135 16%

Thanks
Stu