+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting to Highlight Cell if Delivery Date is Greater than the Due Date

  1. #1
    Forum Contributor
    Join Date
    02-23-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2016
    Posts
    171

    Conditional Formatting to Highlight Cell if Delivery Date is Greater than the Due Date

    Hi Experts
    I have searched here for a solution to my problem and havenít been able to find anything suitable and need some help with please
    What I need help with is a Conditional Formatting formula
    I have two date columns in my file
    Column F (Due Date); Column G (Actual Date)
    If the date in G is > than the date in F. Highlight the cell in column G else do nothing
    The dates are not fixed and are all different and thatís what is my issue. If I had a fixed date in a cell, it would have been an easier solution
    Can someone please help me? I have attached a test file
    Regards
    Rahul
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,050

    Re: Conditional Formatting to Highlight Cell if Delivery Date is Greater than the Due Date

    Please select G6:G9 > Press Alt H L N > Use a formula

    =G6>F6 > Fill red
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-23-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2016
    Posts
    171

    Re: Conditional Formatting to Highlight Cell if Delivery Date is Greater than the Due Date

    Thanks, Bo
    Very much appreciated

    Regards
    Rahul

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,124

    Re: Conditional Formatting to Highlight Cell if Delivery Date is Greater than the Due Date

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


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


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ 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] highlight cell through conditional formatting if the date matches ?
    By VICTOR5 in forum Excel General
    Replies: 7
    Last Post: 01-01-2019, 02:11 AM
  2. [SOLVED] Use Conditional Formatting to Highlight Date Due if Text in Another Cell
    By mrsdeapsleap in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2015, 02:33 PM
  3. [SOLVED] Conditional Formatting: If Date in cell A1 is greater than 7 days old, flag B1 If blank
    By shepherdc2814 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2013, 11:09 AM
  4. Conditional formatting to alert me when a delivery date is due
    By Rex81 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2013, 10:28 PM
  5. Replies: 5
    Last Post: 08-22-2012, 05:06 PM
  6. Replies: 5
    Last Post: 07-03-2012, 01:23 PM
  7. Replies: 2
    Last Post: 12-27-2011, 04:25 PM

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