Results 1 to 5 of 5

Highlighting cells according to dropdown list and date

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2018
    Location
    Ponta Delgada
    MS-Off Ver
    Microsoft excel 2016
    Posts
    2

    Highlighting cells according to dropdown list and date

    Hi,

    Ok so I've been trying to do this but haven't been able to, so maybe you guys can help me here.
    In my job I have to receive documents periodically (monthly, every two months, every 6 months, etc.). There is also a yearly deadline. In front of the table below I have a month table (Ag/18,sept/18 and so forth)

    Example:
    Account__Start of Date___Deadline______Frequency
    __A______1/8/2018_____3 years_____every 6 months
    __B______23/5/2017____5 years_____every 3 months

    Want I'm looking for is to highlight the months I'm supposed to receive the documents using dropdown list of frequency so that they will automatically highlight the given months starting from the "start of Date" field.
    So, in Example A, as I fill the info it would highlight every February and August, for 3 years straight.

    Is It possible??

    Thank you guys for any feedback
    Last edited by dubfinder; 08-24-2018 at 08:02 AM. Reason: Poor formatting2

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Highlighting Duplicate Date Using Two Cells
    By mowens74 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2018, 04:50 AM
  2. highlighting cells based on dropdown selection
    By thatgirl84 in forum Excel General
    Replies: 3
    Last Post: 02-03-2016, 04:05 PM
  3. Replies: 11
    Last Post: 11-27-2015, 03:29 PM
  4. Highlighting cells via a DropDown
    By pigpen in forum Excel General
    Replies: 1
    Last Post: 09-11-2014, 10:57 AM
  5. Replies: 13
    Last Post: 03-28-2014, 12:45 AM
  6. Date dropdown list and a Time dropdown list in outlook
    By L_ter in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2009, 02:33 AM
  7. Highlighting date cells
    By aldawson38 in forum Excel General
    Replies: 7
    Last Post: 06-23-2008, 11:09 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