Results 1 to 5 of 5

Conditional Formatting - time based

Threaded View

  1. #1
    Registered User
    Join Date
    08-03-2015
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    38

    Conditional Formatting - time based

    Hello,

    I have a spreadsheet where I am tracking a project with different timelines, and I would like to figure out a conditional format to make it highlight certain cells based on the due date.

    I would like these cells to get highlighted a certain color when the due date is next week. Perhaps I can have a few different colors depending on the day.

    I have attached a spreadsheet with a simple example of two columns.

    If the date in Column B is this coming Friday, I would like Column A to be Red.
    If the date in Column B is next Friday, I would like Column A to be Yellow.
    If the date in Column B is the following Friday, I would like Column A to be Green.
    If the date in Column B happens to be further than 2 Friday's out, then I would want Column A to be Blue.

    Regardless of the due date, though, I do want Column A to be highlighted if the cell in Column B is not blank; which based on the above, it would be Blue if it was far out in the future.

    How can I do this?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional formatting of formula based time
    By roland willems in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-24-2017, 03:02 PM
  2. Time-Based Conditional Formatting With Offset
    By joseph.wolfenberger in forum Excel General
    Replies: 1
    Last Post: 06-21-2016, 04:04 PM
  3. conditional formatting based on time difference
    By arindamsenaxa in forum Excel General
    Replies: 4
    Last Post: 11-28-2014, 10:58 AM
  4. Conditional Formatting - Based on Time
    By haroon284 in forum Excel General
    Replies: 6
    Last Post: 09-08-2014, 04:47 AM
  5. Replies: 5
    Last Post: 11-27-2013, 06:04 PM
  6. Conditional Formatting Based on Time Window
    By sdoremus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2008, 04:48 PM
  7. Conditional formatting based on time
    By sharkey in forum Excel General
    Replies: 2
    Last Post: 12-24-2007, 02:13 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