Results 1 to 8 of 8

Conditional Formatting - Using Date and additional value

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2013
    Location
    Colorado Springs, CO
    MS-Off Ver
    Excel 2007
    Posts
    5

    Conditional Formatting - Using Date and additional value

    I'm trying to use a conditional format to change cell B7 either red or yellow

    B7 Value: 4/17/13
    C7 Value: 6 - (This means 6 months from the above date we have to turn it back in.

    So I wanted to make cell B7 Red when we exceed 6 months from original date and I wanted to make cell B7 Yellow when we are 1 month prior to the total time (6 months).

    If this is not possible my other option is to have the dates in cell K-Q:7 change colors (as stated above) using the values in B7 and C7.

    I would really appreciate someone's help, I can't find an answer online because I'm using and extra cell that lists the months total we can have an item out


    Thanks
    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. [SOLVED] Additional Conditions for Conditional Formatting
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 11:05 AM
  2. [SOLVED] Additional Conditions for Conditional Formatting
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  3. Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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