+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting to Highlight Blank Cells based on the Date in Another Cell

  1. #1
    Forum Contributor
    Join Date
    01-16-2020
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    171

    Conditional Formatting to Highlight Blank Cells based on the Date in Another Cell

    I have a tracking spreadsheet, and I am looking to highlight cells in column H if the date in column E is more than 182 days in the past only if the cells in column H are blank.
    Not sure if I'm explaining this well, so let me give an example based on today's date, 1/25/2022.

    182 days before today is July 27, 2021. So, let's say that we have the following information in this table:

    Please Login or Register  to view this content.
    In the above example, I need cell H1 to highlight, but cell H2 should not be highlighted because it isn't blank.

    Any help is much appreciated!

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Conditional Formatting to Highlight Blank Cells based on the Date in Another Cell

    Try this in your CF dialogue box, (use a formula. . .)

    Please Login or Register  to view this content.
    Format as desired, mark as SOLVED if all is good.

    Pete

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,881

    Re: Conditional Formatting to Highlight Blank Cells based on the Date in Another Cell

    CF rule for H1:

    =AND(E1<=(TODAY()-187),H1="")

    Applies to: =$H$1:$H$2

    AliGW on MS365 Insider (Windows) 64 bit

    E
    F
    G
    H
    1
    21/07/2021
    2
    27/07/2021
    05/01/2022
    Sheet: Sheet1
    Attached Files Attached Files
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Contributor
    Join Date
    01-16-2020
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    171

    Re: Conditional Formatting to Highlight Blank Cells based on the Date in Another Cell

    Awesome; thank you so much to both of you! I really appreciate your help.
    Both solutions work as expected.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,881

    Re: Conditional Formatting to Highlight Blank Cells based on the Date in Another Cell

    You're welcome.

+ 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: 10
    Last Post: 12-29-2021, 05:09 PM
  2. [SOLVED] Conditional Formatting: Highlight specific cell based on a date
    By Jacolene in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-09-2020, 08:21 AM
  3. [SOLVED] Conditional formatting for blank cell based on another cells date
    By trent88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2019, 12:50 PM
  4. [SOLVED] Conditional Formatting: If a cell is blank after due date, highlight said cell
    By Deaco in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-06-2019, 08:08 AM
  5. Replies: 3
    Last Post: 06-08-2017, 07:31 PM
  6. Replies: 4
    Last Post: 02-13-2013, 01:18 PM
  7. Replies: 5
    Last Post: 04-22-2011, 02:50 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