+ Reply to Thread
Results 1 to 7 of 7

Conditional Formatting - 52 week schedule, highlighting weeks at conditional intervals.

  1. #1
    Registered User
    Join Date
    02-08-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Conditional Formatting - 52 week schedule, highlighting weeks at conditional intervals.

    I have a 52 week calendar with weeks 1-52 in columns, and tasks listed in rows.

    I cannot for the life of me figure out how to highlight cells based of the earliest entry on a task row. For example; Task A is scheduled to be completed once every 4 weeks. If the first occurrence of the task is week 2, then I would like to highlight week 6, 10, 14, etc...as being due for completion again.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Conditional Formatting - 52 week schedule, highlighting weeks at conditional intervals

    In what cell is the 4 for Task A indicating the interval?

    Your'e better off posting a file

    Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    02-08-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Re: Conditional Formatting - 52 week schedule, highlighting weeks at conditional intervals

    Attached Example file. For reference I manually filled in the first few tasks with how I would like it to do automatically.

    Thank you for your time.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    873

    Re: Conditional Formatting - 52 week schedule, highlighting weeks at conditional intervals

    Try this in Conditional Formatting:

    =MOD(COLUMN(),$C7)=0

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,249

    Re: Conditional Formatting - 52 week schedule, highlighting weeks at conditional intervals

    Insert a column to show the start week.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  6. #6
    Registered User
    Join Date
    02-08-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Re: Conditional Formatting - 52 week schedule, highlighting weeks at conditional intervals

    Bump for help!

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,256

    Re: Conditional Formatting - 52 week schedule, highlighting weeks at conditional intervals

    The attached file shows how kvsrinivasamurthy's suggestion and a modification of Estevaoba's formula can be used to conditionally format the chart.
    I only applied the rule to rows 11:15 so that you could see that it matches the cell pattern in rows 7:10
    If you wanted to apply the formula to the range, E7:BD15 it would read: =OR(COLUMN()=$D7,MOD(COLUMN(A:A),$C7)=$D7,$C7=1)
    Note: column D may be hidden for aesthetic purposes.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Highlight week number using Conditional formatting - shows incorrect week
    By spliffter in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-26-2016, 09:52 AM
  2. [SOLVED] Use Conditional Formatting to Hide Future Weeks
    By jimboryan in forum Excel General
    Replies: 3
    Last Post: 10-30-2015, 10:51 AM
  3. [SOLVED] Conditional Formatting to show week over week improvement/decline
    By erikw48 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-15-2015, 10:22 AM
  4. Conditional Formatting Formula - Date & Time for intervals
    By jamesfxd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2015, 12:23 AM
  5. Replies: 2
    Last Post: 05-29-2012, 02:26 PM
  6. Conditional Formatting intervals
    By Kagesen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2011, 04:32 AM
  7. conditional formatting weeks
    By minkus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2008, 06:00 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