Results 1 to 8 of 8

Conditional Formatting/COUNTIF help with multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    12-28-2018
    Location
    Sioux Falls, SD, USA
    MS-Off Ver
    Office 365 Professional
    Posts
    3

    Conditional Formatting/COUNTIF help with multiple criteria

    Let me start this off by saying I am not a professional, and am so uneducated that I don't even know that I have the right search terms (because I couldn't find an answer, I did try) or the best formula for this solution.

    Okay, so. What I have is a multiple page spreadsheet; page one is "Active" (all clients; unique ID number, first and last names, and a column for each type of report), page 2 is "Pending," (clients ID#, name, and whichever specific provider a request has been sent out, and the date out) and page 3 is "Received" (all of the received reports from page 2, with added received and effective dates).

    I have a number of conditional formatting rules in place, including one to make sure that reports are not duplicated using a helper column and COUNTIF on pages 2 and 3, and another COUNTIF to highlight the first names of clients on page 1 that have an entry on page 2 (using the unique ID# but highlighting the name cell).

    What I'm trying to do - using similar logic to the second rule mentioned above - is create a rule where I can make the second name be highlighted on page 1 if there is an entry on page 3 AFTER a certain date, in a cell that I can change as I update the Active page by adding the information in the Received page.

    I'm close, I think! I tried some other functions but ended up using a helper column (might as well) managed to figure out
    =COUNTIF(Received!$L$2:$L$1078,$C2&$P$8)>0
    Where P8 is the last updated date, L is my helper column (ID and date).... but I can only make it EQUAL to P8, not after. That works great, and I guess I could do it one day at a time, but that isn't optimal.

    I know I am close, but I just can't figure out what I can do. I tried adding in a greater than sign but it kept giving me errors and damned it, I am stymied, and I JUST KNOW there is a solution somehow.
    Last edited by kamilynn; 12-28-2018 at 04:22 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting - Multiple Criteria
    By zobrien in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-24-2017, 07:52 AM
  2. [SOLVED] Conditional Formatting over multiple cells with multiple criteria validator
    By effendrew in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-31-2015, 05:05 PM
  3. [SOLVED] Conditional Formatting - Multiple Criteria
    By Spencer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2014, 10:36 PM
  4. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  5. Conditional formatting with Multiple Criteria
    By kgibson20 in forum Excel General
    Replies: 5
    Last Post: 05-21-2012, 02:00 PM
  6. Conditional formatting multiple criteria
    By imcurious in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-28-2011, 05:36 AM
  7. Conditional Formatting with multiple AND/OR criteria
    By camdameron in forum Excel General
    Replies: 7
    Last Post: 11-02-2010, 02:03 PM

Tags for this Thread

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