+ Reply to Thread
Results 1 to 4 of 4

Hello....help with training matrix conditional formatting

  1. #1
    Registered User
    Join Date
    09-10-2019
    Location
    Felixstowe, Suffolk
    MS-Off Ver
    2003
    Posts
    0

    Hello....help with training matrix conditional formatting

    Hello everyone.
    I would like to do training dates matrix, using red amber green, so for training that is due every year, I would like to do formula for;

    Date of training, to
    Show as green if date 121 days to 365 days until next due.
    Show amber if date span less than 120 days until due next.
    Show red if date less than 60 days left until due next.

    So recap (yearly) 365 days training, red at 60 days or less, amber 120 days or less, green at 121 days to 365.

    Suggestions please.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Claire1273,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-10-2019
    Location
    Felixstowe, Suffolk
    MS-Off Ver
    2003
    Posts
    0

    Re: Hello....help with training matrix conditional formatting

    Thank you

  4. #4
    Registered User
    Join Date
    09-10-2019
    Location
    Felixstowe, Suffolk
    MS-Off Ver
    2003
    Posts
    0

    Re: Hello....help with training matrix conditional formatting

    Thank you

+ 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. Training Matrix date formula [conditional formatting for expiry]
    By CaptainScamp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2019, 11:36 AM
  2. Conditional Formatting Training Matrix
    By rambai in forum Excel General
    Replies: 6
    Last Post: 01-16-2019, 07:58 AM
  3. Training Matrix - Conditional Formatting for dates occuring
    By Smannarn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2016, 11:37 AM
  4. Replies: 1
    Last Post: 10-09-2014, 08:29 AM
  5. [SOLVED] Conditional Formatting for Training Expiration Dates
    By jeff.kennedy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2014, 11:58 AM
  6. Training matrix traffic lights conditional formatting
    By buju247 in forum Excel General
    Replies: 6
    Last Post: 11-29-2013, 05:44 AM
  7. Conditional Formatting Training Matrix Dates
    By hamiltg02 in forum Excel General
    Replies: 2
    Last Post: 05-01-2013, 05:49 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