+ Reply to Thread
Results 1 to 4 of 4

Conditional format if multiple criteria is met

  1. #1
    Registered User
    Join Date
    04-19-2015
    Posts
    7

    Conditional format if multiple criteria is met

    Basically In column a are military ranks and column b are the dates they were promoted.

    I'm looking to get a conditional format formula to change the color of the row if they were promoted on or before a certain date AND if they are a certain rank.

    I have formulas for each individually but nothing that I have tried works to combos them.. I would leave them separate but after about the 3rd rank it messes it up and back to square one.

    Here is what I got:

    =$a7="PVT"
    =$a7="PFC"
    =$a7="LCPL"
    =if($d7>=datevalue("1/31/2015"),true,false)
    =if($d7<=datevalue("1/31/2015"),true,false)

    Essentially if they are a LCPL and promoted before Jan 31 color them blue
    After color them red
    Pfc before yellow
    Pfc. After green
    PVT just orange


    Thanks folks!


    Sent from my iPhone using Tapatalk

  2. #2
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Conditional format if multiple criteria is met

    Hi,

    Consider posting sample file.

    Regards,
    AM

  3. #3
    Registered User
    Join Date
    04-19-2015
    Posts
    7

    Re: Conditional format if multiple criteria is met

    Quote Originally Posted by ashishmehra2010 View Post
    Hi,

    Consider posting sample file.

    Regards,
    AM
    As soon as I am able too I will, but as this is my iPhone and cannot access this page from our computers I cannot.


    Sent from my iPhone using Tapatalk

  4. #4
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Conditional format if multiple criteria is met

    Hi Pylican,

    Please check the file.

    I have attached image so that you can check over phone.

    Regards,
    AM

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional format with multiple criteria
    By mxsc in forum Excel General
    Replies: 8
    Last Post: 04-30-2015, 10:33 AM
  2. [SOLVED] Conditional format based on multiple criteria
    By Kandy1084 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2014, 01:36 AM
  3. Conditional Format Multiple Criteria VBA
    By SamsamF in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2011, 08:45 AM
  4. [SOLVED] Conditional Format based on multiple criteria
    By maw230 in forum Excel General
    Replies: 9
    Last Post: 02-16-2010, 06:24 PM
  5. multiple criteria conditional format with date proximity
    By B. Baumgartner in forum Excel General
    Replies: 3
    Last Post: 01-13-2007, 08:31 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1