+ Reply to Thread
Results 1 to 4 of 4

Highlight cells between 1 reference cell and last filled cell on Row

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Sparta, TN
    MS-Off Ver
    Excel 2007
    Posts
    2

    Highlight cells between 1 reference cell and last filled cell on Row

    I'm sorry if this is answered in another thread, I tried searching but didn't find anything like what I was trying to do. I have a report that tracks an order through production processes. The order will go through many different processes before reaching completion, but all orders do not go through all of the same processes. What I'm trying to do is highlight all cells between the order entry date and the last cell in that row that has a filled in cell, that way visually it would show how far the order has progressed. I attached an example of what I am trying to accomplish. I would like to be able to do this automatically, but am unsure of how to accomplish that. I can create a conditional format that highlights all cells that have data, but obviously that leaves the ones in between blank. Thank you for any help you can give, and I apologize again if this is a stupid question or has been answered somewhere else.
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,749

    Re: Highlight cells between 1 reference cell and last filled cell on Row

    try using conditional format and use the formula

    =NOT(COUNTIF(B2:$N$2,"<>"&"")=0)

    see attached - green fill upto last entered text

    to apply to other rows
    this formula should work
    =NOT(COUNTIF(B2:$N2,"<>"&"")=0)
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    08-06-2013
    Location
    Sparta, TN
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Highlight cells between 1 reference cell and last filled cell on Row

    Man, that worked great! Thank you very much for the help.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,749

    Re: Highlight cells between 1 reference cell and last filled cell on Row

    your welcome

+ 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. Replies: 12
    Last Post: 07-10-2012, 05:04 PM
  2. Replies: 2
    Last Post: 02-29-2012, 11:55 AM
  3. mandatory cells only if another cell is filled
    By RA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2006, 12:45 PM
  4. [SOLVED] lock cells until one cell is filled
    By Debbie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2006, 01:45 PM
  5. Replies: 5
    Last Post: 05-27-2005, 02:05 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