+ 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 (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,315

    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    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 (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,315

    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