+ Reply to Thread
Results 1 to 3 of 3

collor 2 or 3 cells in a week

  1. #1
    Forum Contributor
    Join Date
    12-25-2012
    Location
    gent,belgium
    MS-Off Ver
    Excel 2021
    Posts
    146

    collor 2 or 3 cells in a week

    in the file i set de color cell yello en green cel by hand.

    In the year 2020 the yello
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: collor 2 or 3 cells in a week

    I have looked - no idea what your logic is, sorry.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    12-25-2012
    Location
    gent,belgium
    MS-Off Ver
    Excel 2021
    Posts
    146

    Re: collor 2 or 3 cells in a week

    I have manual collor the hollidays when a person works half time.
    One week he works 3 days the other week he works 2days

    I want that de user can select the days in 3 cells the days that he not work. Then collor the cells that he is not at work. In 2020 he have to work 3 days in week 1 en 2 workingdays in week two.
    What i alredy found is where here are 53 weeks in a year the 3 days work week are in the oneven weeknr. And by 52 weeks thy are in the even weeks.
    What is the formula of function to detect that
    3 days work in the even or oneven weeks are so that the 2days work week in the other week and then collerd 2 ore 3 cells for not working

+ 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. [SOLVED] replace problem and collor a row after 6 and 8 weeks
    By blake20 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2017, 09:13 AM
  2. How to: identify repeat offenders within a 3 week period (week per week basis)
    By Heloc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2012, 12:43 AM
  3. Change week row every week with clear cells
    By adamsurpren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 11:45 AM
  4. Update to week of X every week and clear cells
    By adamsurpren in forum Excel General
    Replies: 3
    Last Post: 06-12-2012, 07:32 AM
  5. Changing Row collor based on one cell - Repeat
    By lmcsyll in forum Excel General
    Replies: 2
    Last Post: 10-12-2009, 07:52 AM
  6. How to collor certain areas of a chart
    By Piemonte in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-26-2007, 01:24 PM
  7. [SOLVED] how do I change the fill collor os a cell using a function in VB
    By Jason R Morris in forum Excel General
    Replies: 3
    Last Post: 01-27-2006, 07:35 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