Using minus values in conditional formatting

[handshandy]

Hey, first time on the board.

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

For example:

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

Thanks
St

 

[Claus Busch]

Hi Stu,

Am Fri, 11 Oct 2013 11:59:55 +0100 schrieb handshandy:

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

try:
=ABS(C2)<=0.05


Regards
Claus B.