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
     
    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:

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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jiffy
    Replies:
    4
    Views:
    97
    Tushar Mehta
    Feb 10, 2004
  2. Don Guillett
    Replies:
    2
    Views:
    124
    Don Guillett
    Jun 3, 2004
  3. linda

    Plus and Minus Sign

    linda, Jul 26, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    114
    JulieD
    Jul 26, 2004
  4. marto_martin

    how do i get a formula to ignore minus figures

    marto_martin, Sep 12, 2004, in forum: Excel Beginners
    Replies:
    2
    Views:
    76
    Frank Kabel
    Sep 12, 2004
  5. kevhatch

    minus numbers causing a problem

    kevhatch, Jun 21, 2005, in forum: Excel Beginners
    Replies:
    14
    Views:
    181
  6. ED

    I want to display the minus sign

    ED, Oct 26, 2005, in forum: Excel Beginners
    Replies:
    7
    Views:
    145
    gls858
    Oct 27, 2005
  7. Paul Bennett

    converting minus quantities to plus

    Paul Bennett, Nov 13, 2005, in forum: Excel Beginners
    Replies:
    4
    Views:
    105
    Bill Ridgeway
    Nov 14, 2005
  8. kang
    Replies:
    6
    Views:
    98
Loading...