+ Reply to Thread
Results 1 to 2 of 2

conditional formatting of rows based on dates compared with today.

  1. #1
    Registered User
    Join Date
    05-11-2020
    Location
    Edmonton, Alberta
    MS-Off Ver
    365
    Posts
    8

    conditional formatting of rows based on dates compared with today.

    I am trying to highlight particular rows in a RFI log based on a due date (orange for due date coming up, Red for due date passed with no response, but turning green for those where an answer was received, even if it is passed the due date. Scaled coloring would be nice, but not necessary. I have tried a number of things and scoured the internet, but I am stumped so far. Anybody able to help me out? I have attached a copy of the spreadsheet. Also, it cannot be based on a macro, as i want to use it in Microsoft Teams, and i recently discovered that Macros' apparently don't work in TEAMS.
    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 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,300

    Re: conditional formatting of rows based on dates compared with today.

    orange for due date coming up,
    Red for due date passed with no response,
    green for those where an answer was received

    Three Rules, one for each colour
    GREEN
    =$L7<>""
    ORANGE
    =AND($H7 >= TODAY(),$H7 <> "",$L7="")
    RED
    =AND($H7 < TODAY(),$H7 <> "")

    see attached
    Attached Files Attached Files
    Last edited by etaf; 05-12-2020 at 11:46 AM.
    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.

+ 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] Conditional Formatting - Dates older than Today
    By Wheelie686 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-06-2018, 08:34 AM
  2. [SOLVED] Conditional Formatting for Dates from Today
    By Hedy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-07-2018, 01:03 PM
  3. Conditional Formatting - based on a cell value compared to values in a table
    By John Steel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-08-2017, 04:17 PM
  4. Conditional formatting with dates NOT based on today
    By bionerdette in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2014, 07:13 PM
  5. [SOLVED] Conditional Formatting between two dates that are not today!
    By IreneADS in forum Excel General
    Replies: 12
    Last Post: 01-15-2014, 05:42 PM
  6. [SOLVED] Conditional Formatting of: dates within 1 month and dates before today.
    By Luke Smith in forum Excel General
    Replies: 5
    Last Post: 06-18-2013, 07:29 AM
  7. [SOLVED] Conditional Formatting Rows Based on Dates
    By vinceancona in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 11:53 AM

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