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

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.