Results 1 to 11 of 11

auto border every 4 week on the right

Threaded View

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

    auto border every 4 week on the right

    hi
    I have made a calandar and every 4 weeks i need a red tick line on the right of the cels.

    So for 2017 the first line is on the weeknumber 3 than 7 than 11 and the last line for 2017 is in week 51
    But when i change the year the lines must auto change
    so for 2018 it must be week 3 7 11 15 and so on
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove border from legend entry without removing border from pie chart
    By cartman88 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-06-2015, 04:16 AM
  2. [SOLVED] Need help auto-updating a formula for week over week change
    By yanger87 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2015, 12:45 PM
  3. [SOLVED] Generate Auto week no.
    By joh46k in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-25-2013, 11:20 PM
  4. Replies: 1
    Last Post: 03-29-2011, 08:22 AM
  5. create border across entire row based on current week
    By sentofuno in forum Excel General
    Replies: 8
    Last Post: 01-22-2008, 09:03 AM
  6. Replies: 1
    Last Post: 08-11-2005, 09:05 PM
  7. Auto-update when the week changes
    By jzullo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2005, 08:07 AM

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