+ Reply to Thread
Results 1 to 4 of 4

Help With conditional formatting and =WEEKNUM(NOW())

  1. #1
    Registered User
    Join Date
    12-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    14

    Help With conditional formatting and =WEEKNUM(NOW())

    Cell A1 contains the date 2/16/18 which falls withing week 7 and the formula =WEEKNUM(NOW()) Returns the value 7 meaning we are in the 7th week if the year.

    I would like to apply conditional formatting to cell A1 so that if the date in the cell falls withing the current week it is highlighted and if the date falls outside the current week it does not

    Thank You

  2. #2
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Help With conditional formatting and =WEEKNUM(NOW())

    maximiianrg, Good evening.

    Try to use this formula at Conditional Format:

    Please Login or Register  to view this content.
    Please, tell us if it worked as necessary.

    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marc?lio Lob?o

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Help With conditional formatting and =WEEKNUM(NOW())

    Select A1 > Conditional Formatting > New Rule > Use a formula

    =WEEKNUM(A1)=WEEKNUM(TODAY())

    Format: Fill whatever color you'd like > OK

  4. #4
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Help With conditional formatting and =WEEKNUM(NOW())

    Can you give a small example of what have until now ?
    Kind regards,
    Piet Bom

+ 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] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  2. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  3. Replies: 4
    Last Post: 11-25-2015, 06:44 PM
  4. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  5. Date formatting weeknum coming out wrong
    By Tradesman in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-30-2012, 07:37 AM
  6. weeknum formatting
    By Terri in forum Excel General
    Replies: 2
    Last Post: 05-02-2006, 10:20 PM
  7. Conditional Formatting using Formulas and WEEKNUM
    By Kirk in forum Excel General
    Replies: 4
    Last Post: 12-22-2005, 01:20 PM

Tags for this Thread

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