+ Reply to Thread
Results 1 to 4 of 4

Dates conditional formatting help needed (PLEASE AND THANK YOU)

  1. #1
    Registered User
    Join Date
    10-20-2022
    Location
    NJ, US
    MS-Off Ver
    2016
    Posts
    2

    Unhappy Dates conditional formatting help needed (PLEASE AND THANK YOU)

    Hello all,

    I have attached a small sample file for reference; in reality my files are much larger hence the need for help.

    I need help with specialized conditional formatting. As you will notes, Col. B has "Order dates" and Col. C has "Production date"; some dates for Col. C are filled others are not.

    How would I go about formatting in a way where, EMPTY Col C "production dates" cells are highlighted when Order date + 30 days (or whatever amount of days I choose) are compared with the CURRENT date. If Order date + 30 days is LESS than today's date, then the empty Col. C "production date" cell would be highlighted.

    I would really appreciate some help on this as it would dramatically reduce my time on these reports. Once again much thank you in advance!

    Regards.
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Dates conditional formatting help needed (PLEASE AND THANK YOU)

    how about
    =AND(C3="", A3<>'"', INT(A3)+30<TODAY())

    Select C3 to C1000 o

    for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
    Conditional Formatting

    Highlight applicable range >>
    C3:C100 - Change, reduce or extend the rows to meet your data range of rows

    Home Tab >> Styles >> Conditional Formatting
    New Rule >> Use a formula to determine which cells to format
    Edit the Rule Description: Format values where this formula is true:
    =AND(C3="", A3<>'', INT(A3)+30<TODAY())

    Format [Number, Font, Border, Fill]
    choose the format you would like to apply when the condition is true
    OK >> OK
    Attached Files Attached Files
    Last edited by etaf; 10-20-2022 at 03:09 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    10-20-2022
    Location
    NJ, US
    MS-Off Ver
    2016
    Posts
    2

    Re: Dates conditional formatting help needed (PLEASE AND THANK YOU)

    Thank you! It worked!!! Just a small correction as the formula you posted had a missing character but obviously it was right in the Excel file you attached.

    For those looking to copy the formula: =AND(C3="", A3<>"", INT(A3)+30<TODAY())

    I am pushing myself to go into data analysis. It seems you're an Expert at Excel to say the least. Do you have any tips on where to acquire advanced knowledge about Excel formulas and such? Idk if the answer you gave is considered advanced or intermediate, but it's advanced to me lol.

    Most sincere gratitude.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Dates conditional formatting help needed (PLEASE AND THANK YOU)

    you are welcome

    thanks for the correction - i edited the post

    thanks again

    I am pushing myself to go into data analysis.
    loads of ways to learn, various courses on youtube, if you learn that way - OR books

    Also following forum, looking at questions here and then see what solutions are offered - often you will see 2 or 3 different ways to do things

+ 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: 5
    Last Post: 12-03-2020, 01:45 PM
  2. Replies: 11
    Last Post: 05-04-2014, 08:28 PM
  3. Help needed with conditional formatting
    By Denpar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-25-2013, 04:00 PM
  4. [SOLVED] Help Needed on Conditional Formatting
    By szpt9m in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2013, 11:18 PM
  5. Conditional formatting help needed for due dates
    By lschultz381 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-08-2013, 02:55 PM
  6. Conditional formatting needed for shape colour - is programming needed?
    By Farmboyuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 07:27 AM
  7. conditional formatting Help needed
    By lugtonex in forum Excel General
    Replies: 2
    Last Post: 04-26-2011, 12:42 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