Results 1 to 11 of 11

Highlight row based on cell value and weeknumber

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2015
    Location
    Nederland
    MS-Off Ver
    2010
    Posts
    33

    Highlight row based on cell value and weeknumber

    I would like to highlight the object cell when there is an value in the the same row and week is highlighted.

    using =C$2=WEEKNUMMER(VANDAAG()) to highlight week.

    Example:

    objects 3, 7 and 10 should be also higlighted because they have a value in the active week

    something like: when contains value and in active week (column) then highlight cell in column "B" row x
    Attached Files Attached Files
    Last edited by Milcoi; 02-28-2017 at 06:31 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight part of cell based off another
    By earthandbody in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2016, 07:50 AM
  2. [SOLVED] cumulatively count row based on weeknumber and cell value
    By Gjanus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2016, 11:31 AM
  3. [SOLVED] Highlight cell based on total quantity value based on repeated order numbers
    By PWilson0727 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2014, 02:02 PM
  4. [SOLVED] Highlight cell based on selected cell - Code required
    By SharpL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-24-2014, 09:48 AM
  5. Replies: 1
    Last Post: 01-20-2014, 03:52 AM
  6. [SOLVED] Add Weeknumber value to cell depending on the date in a cell 4 columns away
    By Roxner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2013, 02:37 PM
  7. Highlight a Row based on a cell
    By webstar in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-16-2007, 01:50 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