+ Reply to Thread
Results 1 to 3 of 3

Help with highlighting cell colour based on the conditions (# of days) of another cell

  1. #1
    Registered User
    Join Date
    07-29-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    16

    Help with highlighting cell colour based on the conditions (# of days) of another cell

    Hello,

    I have been trying to work on this with conditional formatting for a couple of days now to no avail

    Here is a photo of the chart I'm working with:

    SampleSheet.jpg

    I have made it so that every time a "FILE NUMBER" is entered the cell to the right in grey shows the date it was entered in dd-Mmm-yy (ex. file number is C8 date is entered in D8).

    Now what I need is a macro or conditional formatting that will highlight the "Motion" (B, E...) and "FILE NUMBER" (C, F...) cells in red when 10 ***business/work days have passed from the initial date entered in the corresponding grey cell (D, G, J...).

    I wanted to use WORKDAY, but the cells are filled at random dates so I don't know what the start date would be. It's not a project with a duration. I want to use today, but it doesn't incorporate workdays.

    Please help! Thank you!

  2. #2
    Registered User
    Join Date
    07-29-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    16

    Re: Help with highlighting cell colour based on the conditions (# of days) of another cell

    SampleSheet.jpg

    Sorry, here is the chart again

  3. #3
    Registered User
    Join Date
    07-29-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    16

    Re: Help with highlighting cell colour based on the conditions (# of days) of another cell

    SampleSheet.jpg

    Sorry, here is the chart again

+ 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. Replies: 8
    Last Post: 06-29-2014, 10:01 AM
  2. [SOLVED] Colour a cell based on 2 conditions
    By gjjh25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2012, 08:02 AM
  3. [SOLVED] Highlighting a cell when specific conditions met
    By jpsprack in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 06:22 PM
  4. Changing colour of a cell based on several conditions
    By jennapayne in forum Excel General
    Replies: 2
    Last Post: 03-31-2011, 09:03 AM
  5. [SOLVED] Using Conditions - cell colour and cell containign text
    By Hamish in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2006, 07:00 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