+ Reply to Thread
Results 1 to 3 of 3

One column reads number from another column and base on number of days highlights

  1. #1
    Registered User
    Join Date
    12-04-2015
    Location
    NC, USA
    MS-Off Ver
    2013
    Posts
    18

    One column reads number from another column and base on number of days highlights

    Hello struggling with a conditional formatting any help would be appreciated.
    So column be is populated 6 months (6 month from assigned date) from column G's (date assigned) date Trying to I would like

    1. If number in column in G is from 1 to 2.0 months from correlation date of column b column B is amber ( or green for 76 days instead of 2.5 months)
    2. If number in column in G is from 2.5 to 3.5 months from correlation date of column b column B is light pink (or turns yellow after 77 days instead 2.5
    months)
    3. If number in column in G is from 5 to 6 months from correlation date of column b column B is red (or turns yellow after 122 days instead 4
    months)
    4. If number in column in G is from 4 to 5 months from correlation date of column b column B is green (or turns yellow after 122 days instead 5
    months)

    See Attached. Thanks everyone.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: One column reads number from another column and base on number of days highlights

    1. There is no data in Column G
    2. It looks like all of your column B dates are exactly 6 months from your "Date Assigned" Are you asking to compare "Assigned Date" to current date?
    Please clarify
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    12-04-2015
    Location
    NC, USA
    MS-Off Ver
    2013
    Posts
    18

    Re: One column reads number from another column and base on number of days highlights

    Sorry for the confusion,

    1. Date in column B is 6 months from date in column E. If date in column in E is 0-30 days cell in column B that correlates with cell in column E will turn green.

    2. ate in column B is 6 months from date in column E. If date in column in E is 31-90 days cell in column B that correlates with cell in column E will turn amber

    ate in column B is 6 months from date in column E. If date in column in E is 31-150 days cell in column B that correlates with cell in column E will turn red.

+ 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. Send email when any cell in a specific column reads below a certain number...
    By afihavok in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-31-2017, 01:05 PM
  2. Update date column with number of days in another column using vba
    By ajitexcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-16-2017, 05:49 AM
  3. [SOLVED] Count number of days in column without an end date?????????
    By EmDubeu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-19-2016, 04:41 PM
  4. Replies: 3
    Last Post: 04-08-2016, 09:11 AM
  5. Replies: 5
    Last Post: 10-18-2013, 12:51 PM
  6. Add Date in Column A Plus Number of Days in Column B and show result in Column C
    By excelforumcrisis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2013, 02:01 PM
  7. Calculate number of days in a column of dates
    By Barbara in forum Excel General
    Replies: 3
    Last Post: 05-25-2005, 11:21 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