Closed Thread
Results 1 to 8 of 8

Filling the cells by color following period between two datums.

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Republic Czech
    MS-Off Ver
    Czech
    Posts
    32

    Filling the cells by color following period between two datums.

    Please check the description in attached file for better understanding.

    I have added logic function where I can change the status for example X (instead of OK) and the cell in the same line and the same column will change from OK to X.

    I would like to keep it as it is but I would like to mark with the same status and color the date from start what in this case is 10.01.2017 till the end 12.01.2017 (look the example in the line 7- (3 cells marked with green color and written condition OK as the date 10.01.2017 + 11.01.2017 + 12.01.2017.

    The solution should be applycable for all table and simply adjustable if possible in case of any future modification.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Filling the cells by color following period between two datums.

    Hi

    Try this in K7 and copy down and right
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Filling the cells by color following period between two datums.

    removed by the author
    Last edited by José Augusto; 01-12-2017 at 01:12 PM. Reason: duplicate

  4. #4
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Filling the cells by color following period between two datums.

    removed by the author
    Last edited by José Augusto; 01-12-2017 at 01:12 PM. Reason: duplicate

  5. #5
    Registered User
    Join Date
    10-16-2014
    Location
    Republic Czech
    MS-Off Ver
    Czech
    Posts
    32

    Re: Filling the cells by color following period between two datums.

    Hi

    I checked it but I have an message error like there is a mistake in the formule

  6. #6
    Registered User
    Join Date
    10-16-2014
    Location
    Republic Czech
    MS-Off Ver
    Czech
    Posts
    32

    Re: Filling the cells by color following period between two datums.

    removed by the author
    Last edited by Topa2; 01-12-2017 at 01:49 PM. Reason: dupicate

  7. #7
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Filling the cells by color following period between two datums.

    For me the formula is correct.

    See the file
    Attached Files Attached Files

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Filling the cells by color following period between two datums.

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread - which you have marked as SOLVED anyway

    http://www.excelforum.com/showthread.php?t=1169498

    Thread Closed.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlighting a row(Filling a row automatically with a different color)
    By dimuthumme in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2015, 06:22 AM
  2. Filling adjacent cells with same fill color
    By watido88 in forum Excel General
    Replies: 3
    Last Post: 01-02-2013, 06:43 PM
  3. [SOLVED] Quickly color filling the backround of every other row.
    By Rixonomic in forum Excel General
    Replies: 3
    Last Post: 12-01-2012, 08:00 PM
  4. [SOLVED] Script for filling cells with specific color
    By adygelber in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2012, 05:01 AM
  5. color filling when I don't ask it to
    By Audi in forum Excel General
    Replies: 1
    Last Post: 02-13-2012, 11:45 AM
  6. change row color after filling one cell
    By kghisla in forum Excel General
    Replies: 9
    Last Post: 10-03-2010, 08:22 AM
  7. Changing text/color after a time period?
    By metalsped in forum Excel General
    Replies: 2
    Last Post: 07-15-2005, 12:53 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