Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Conditional Formatting
    =IF($J17="","",$J17<21)

    =IF($K17="","",$K17>31)

    Is there away to combine these two into one?

    I only want Red on the people under 21 on the appointment date but there age today is over 31 years old


    Last Name , First Name, DOB , Last APPT Date ,SS #, Chart # ,Expired Year or mis info

    A-17 , B-17 , C-17 , D-17 ,E-17, F-17 , G-17


    Box # , VFormula , ApptAge, AGE

    H-17 , I-17 , J-17 , K-17

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    You could just use an AND formula, as in
    =AND($J17 <> "", $J17<21, $K17>31)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •