Using minus values in conditional formatting

Discussion in 'Excel Beginners' started by handshandy, Oct 11, 2013.

  1. handshandy

    handshandy Guest

    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
     
    handshandy, Oct 11, 2013
    #1
    1. Advertisements

  2. handshandy

    Claus Busch Guest

    Hi Stu,

    Am Fri, 11 Oct 2013 11:59:55 +0100 schrieb handshandy:
    try:
    =ABS(C2)<=0.05


    Regards
    Claus B.
     
    Claus Busch, Oct 11, 2013
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.