help with conditional formatting

Discussion in 'Excel' started by bookerk2, May 4, 2011.

  1. bookerk2

    bookerk2

    Joined:
    May 4, 2011
    Messages:
    2
    Likes Received:
    0
    I am trying to add a feature to a payroll workbook the sheet looks like this:
    ST OT CT
    0.00 10.00 0.00
    0.00 10.00 0.00
    0.00 0.00 10.00

    So what I need to do is highlight ST and OT if ST<40 and OT>0. I have tried using data validation for this problem as well as conditional formatting. the last formula I tried was
    =if(d6<40,e6>0,) for the custom conditional formatting rules. Any suggestions here?
     
    bookerk2, May 4, 2011
    #1
    1. Advertisements

  2. bookerk2

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    You aren't the first to have trouble with AND syntax. Try this:

    =AND(D6<40,E6>0)​
     
    XLPadawan, Jun 16, 2016
    #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. build

    maths help

    build, May 1, 2011, in forum: Excel
    Replies:
    2
    Views:
    695
    XLPadawan
    Jun 16, 2016
  2. jsduiahd
    Replies:
    0
    Views:
    590
    jsduiahd
    Jul 26, 2011
  3. Nago
    Replies:
    0
    Views:
    517
  4. DPCpresto
    Replies:
    0
    Views:
    242
    DPCpresto
    Apr 6, 2012
  5. Catw0327

    Timebase help!!!

    Catw0327, Apr 10, 2012, in forum: Excel
    Replies:
    1
    Views:
    649
    XLPadawan
    Jun 16, 2016
  6. Mark

    Help Fill Series

    Mark, Apr 4, 2013, in forum: Excel
    Replies:
    1
    Views:
    1,056
    XLPadawan
    Jun 16, 2016
  7. teza2k06

    Conditional Formatting Formula

    teza2k06, Aug 23, 2014, in forum: Excel
    Replies:
    2
    Views:
    556
    XLPadawan
    Jun 16, 2016
  8. hyukfgh
    Replies:
    2
    Views:
    605
    hyukfgh
    Oct 16, 2014
Loading...