Using minus values in conditional formatting
 

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

Using minus values in conditional formatting
 

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2