+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting for blank cell based on another cells date

  1. #1
    Registered User
    Join Date
    10-24-2019
    Location
    Gold Coast, Australia
    MS-Off Ver
    Office 2013
    Posts
    1

    Conditional formatting for blank cell based on another cells date

    Hi,

    Like many others before me, apologies if this has been answered, but i've searched high and low on the internet, tried the varied suggestions and for some reason, still doesn't work for me.

    My business sends out plans to clients, for which we require their sign off. We chase them up when we remember, but it's getting to a stage that we need something visual to show us exactly what is outstanding, and what is fine.

    The basis is that we enter a date into a cell that a plan has been sent to someone. The next column is blank, but is where we would type in what date the signed plan was received.

    I require a formula (or multiple), that would highlight blank cells that are exceeding 15 days since their corresponding date left of them.

    Please see attached spreadsheet with basic example of what i need.

    Cheers
    Trent

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,837

    Re: Conditional formatting for blank cell based on another cells date

    May be in conditional formatting rule try below formula

    =AND(B2="",(TODAY()-A2)>15)
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,694

    Re: Conditional formatting for blank cell based on another cells date

    Hi and welcoem
    After selectinng a range, D8:D100, say, try =AND($D8="",TODAY()>=$C8+15,$C8<>"") as CF and format as required

  4. #4
    Registered User
    Join Date
    11-14-2019
    Location
    Conroe, Texas
    MS-Off Ver
    2019
    Posts
    1

    Re: Conditional formatting for blank cell based on another cells date

    I am trying to use this code and it works for what I need, but I was wondering if there was a way to apply it to all Cells in a row without having to apply the conditional format to each cell in that row.

    When I select a range for the format to apply to, it bases all the conditions on the original cell (B2) in the formula - is there a way to tell it to move on down the line?

    This is what I get when I select a range:
    A2 feeds off B2
    A3 feeds off B2
    A4 feeds off B2

    I need:
    A2 to feed off B2
    A3 to feed off B3
    A4 to feed off B4
    Last edited by tinaellis; 11-15-2019 at 12:53 PM.

+ 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. Conditional format based on date - formatting blank cells
    By jimmisavage in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2017, 10:50 AM
  2. Replies: 3
    Last Post: 02-09-2015, 09:00 AM
  3. [SOLVED] Conditional Formatting Multiple Cells Based On Date In Other Cell
    By Gtrtim112 in forum Excel General
    Replies: 3
    Last Post: 01-03-2015, 06:18 PM
  4. [SOLVED] Conditional Formatting a blank cell based on another cell's date
    By krista_o in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 04:13 PM
  5. Conditional formatting blank cells based on another cell value
    By 6MPS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2013, 11:59 AM
  6. How to mark cells based on date in other cell using conditional formatting
    By mharsvik in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2012, 12:33 PM
  7. [SOLVED] 3 Outcomes Conditional Formatting based on 4 blank/non blank cells
    By Supraman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2012, 06:21 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