Results 1 to 2 of 2

Thread: Color changing cells by 6 dates with 6 coresoonding colors

  1. #1
    Neophyte Boston221's Avatar
    Join Date
    Apr 2021
    Posts
    2
    Articles
    0
    Excel Version
    office 16

    Color changing cells by 6 dates with 6 coresoonding colors



    Register for a FREE account, and/
    or Log in to avoid these ads!

    We have a shop schedule that is already in use. We would like to add a visual in a dated chart just off to the side that will show the date and if that date in one of those cells is greater than or equal to a date in 6 different cells in the same row we would like the color of the dates with those cells to change to 1 of 6 colors. Showing us exactly what is waiting on which department on any given day. Attached is an example of what we would like it to look like visually but we would like to make these colors populate in the date area (L-NL columns) automatically based on the dates input into the (F-K columns).

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,718
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    This is a duplicate thread and will be closed, as you are allowed only ONE thread per issue here.

    Please continue here: https://www.excelguru.ca/forums/showthread.php?11116
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •