Results 1 to 7 of 7

Highlight column "due date" when passed but not if column "status" says "complete"

Threaded View

HannahWSU Highlight column "due date"... 07-14-2017, 04:15 PM
HannahWSU Re: Conditional formatting... 07-14-2017, 04:16 PM
HannahWSU Re: Highlight column "due... 07-15-2017, 10:46 PM
JohnTopley Re: Highlight column "due... 07-16-2017, 02:29 AM
AliGW Re: Highlight column "due... 07-16-2017, 02:33 AM
HannahWSU Re: Highlight column "due... 07-16-2017, 08:14 AM
JohnTopley Re: Highlight column "due... 07-16-2017, 09:06 AM
  1. #1
    Registered User
    Join Date
    09-30-2015
    Location
    Detroit, Michigan
    MS-Off Ver
    2010
    Posts
    7

    Highlight column "due date" when passed but not if column "status" says "complete"

    Hello,

    I’m having trouble using conditional formatting to highlight cells in my excel attachment.

    I want to highlight cells in column B Due Date, when the due date has passed.
    However, ONLY if Column C does NOT also equal “complete” .
    I want to highlight passed due items, but not if they are already done, because then it doesn’t really matter.
    I tried this formula under conditional formatting> new rule> use a formula…

    =AND(B:B[less than sign]TODAY(),C:C[less than greater than facing each other]"Complete")

    However, nothing highlighted, even when cells like B2 should have because it’s "due date" has passed and it's not “complete”.

    Sorry about the brackets. It won't let me post the formula with the signs saying that it's incorrect HTML code. I attached a snip of the formula with the correct signs.

    Thanks,

    Hannah
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by HannahWSU; 07-16-2017 at 10:48 AM. Reason: clarity

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting formula problem
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-23-2016, 08:41 AM
  2. Conditional formatting problem- not all cells seem to use the formula
    By RattlerSkin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2016, 09:34 AM
  3. [SOLVED] Conditional Formatting formula for shading problem
    By johnsonbj22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-25-2015, 12:58 PM
  4. [SOLVED] Conditional Formatting - Formula Problem?
    By KenMcN in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 03:00 PM
  5. [SOLVED] formula problem w/ conditional formatting
    By edwinculanding in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2013, 05:20 AM
  6. Conditional Formatting using formula needed for the following problem
    By Deepthik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 09:41 AM
  7. Conditional Formatting formula problem
    By ddub25 in forum Excel General
    Replies: 3
    Last Post: 01-21-2010, 08:24 AM

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