+ Reply to Thread
Results 1 to 2 of 2

Difficult Conditional Formatting

  1. #1
    Registered User
    Join Date
    09-02-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    2

    Difficult Conditional Formatting

    I am currently running Excel 2013. I have 1 workbook with 2 sheets. I have attached for reference. Here's what I am wanting to accomplish...

    I want row 2 on "Summary" to be conditionally formatted green if the following 2 criteria are met...
    1. a value is present in the row corresponding with the current month AND....
    2. the current month is equal to the month defined in the "Date Due" column.

    At the end of the current month, I would like for it to "reset" the conditional formatting and then look at row 3 (and so on...) based upon the current date.

    I know this sounds rather complicated. Any help would be MOST appreciated!

    Thank you!
    Attached Files Attached Files
    Last edited by cwdeem; 09-02-2014 at 03:44 PM.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Difficult Conditional Formatting

    Would you put some more data in your file and show us an example of the results you'd like to see?
    Actually, in the Summary sheet, I only see "1st" as due date which is not really a date.
    Thanks
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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] Difficult conditional formatting
    By Solomon14all in forum Excel General
    Replies: 2
    Last Post: 09-25-2012, 07:25 AM
  2. Difficult conditional formatting
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Difficult conditional formatting
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. Difficult conditional formatting
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. Difficult conditional formatting
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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