+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Help

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    Vancouver, Washington
    MS-Off Ver
    2010
    Posts
    9

    Conditional Formatting Help

    Could someone please help me with conditional formatting? I’ve been trying to figure this out with the help of videos and web pages but I could really use an expert.

    We send samples out for micro and heavy metals testing. A sample can be tested for micro, heavy metals, or both. An X is placed in the MIC or HM cell to indicate which test(s) the sample will receive. An IF statement places an “N/A” into the cell where no MIC Report Date or HM Report Date is required.

    What is needed: To have all the cells in the ‘Report Due Date’ column fill with a color if today’s date is greater than the report due date and a cell (same row, column B or C) is empty.

    I guess what I need is if TODAY()>$A$2 and either $B$2 or $C$2 are “”, then fill $A$2 with a color; and to have this for the entire column A.

    I've attached a copy of what I am working on.

    Thank you

    Bob
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Conditional Formatting Help

    With "Today's date" in F1 try this with CF
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Replace the $F$1 with TODAY() when there is data that meets the criteria. Today 6/28/2016 is less than all your dates.
    Last edited by FlameRetired; 06-28-2016 at 02:02 AM.
    Dave

  3. #3
    Registered User
    Join Date
    05-24-2012
    Location
    Vancouver, Washington
    MS-Off Ver
    2010
    Posts
    9

    Re: Conditional Formatting Help

    Thank you for your reply.

    What I failed to mention is that I would like the fill color, in column A, to stop when both cells B and C, beside it, are filled.

    Also, what must I do to apply this same rule to the entire A column?

+ 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. Replies: 9
    Last Post: 03-07-2016, 10:39 AM
  2. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  3. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  4. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  5. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  6. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 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