+ Reply to Thread
Results 1 to 5 of 5

When a cell is highlighted, then ...

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    Illinois
    MS-Off Ver
    Microsoft 360
    Posts
    55

    When a cell is highlighted, then ...

    I work for a printing company and I receive spreadsheets with new jobs that are posted daily. Each row includes a job number, description and the total quantity of pieces that need to be printed. What a job is completed, the production team highlights the row with a specific color. Is there a way to use the highlighted color in a formula, such as "if a cell is a certain color, then place the word "complete" in a specific cell"? I tried just to get the production team to select the word "complete" from a drop down list, but old habits die hard and they can't get away from just highlighting the row. Is this possible? Thanks!

  2. #2
    Forum Expert (Lazarus)
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    .
    Posts
    2,594

    Re: When a cell is highlighted, then ...

    You cannot use formulas to query the internal colour of a cell, but you can use VBA to do so or, as you use 2010, you can sort on cell colours: Data -> Sort -> Sort On "Cell Colour".

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2010
    Posts
    4,332

    Re: When a cell is highlighted, then ...

    how did they determine if the job is complete and to be highlighted ?
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,977

    Re: When a cell is highlighted, then ...

    Vlady asks a good question.
    I suspect the answer is 'They just know from the name of the job' or some such personal knowledge so far unrecorded.

    However even if they're not marking the job complete are there no other fields that are upated from which you can infer a job is complete? Perhaps a date despatched or some such.

    It may be that a macro will be needed.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,878

    Re: When a cell is highlighted, then ...

    Try a differend layout then there are no (or less) "old habits die hard"

    Or take a look at this
    You forced them to select "completed" in column D.
    This can be done with a dropdown box or by double clicking.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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. Highlighted cell
    By life24 in forum Excel General
    Replies: 1
    Last Post: 10-14-2016, 02:32 AM
  2. [SOLVED] Cell highlighted if not certain value
    By nmsmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2015, 02:00 AM
  3. Highlighted cell
    By Sheepkin_Coat in forum Excel General
    Replies: 2
    Last Post: 03-25-2009, 10:06 AM
  4. Replies: 1
    Last Post: 09-03-2006, 05:38 PM
  5. Replies: 1
    Last Post: 09-01-2006, 12:51 PM
  6. [SOLVED] Every cell is highlighted
    By 5hulses in forum Excel General
    Replies: 5
    Last Post: 05-01-2005, 07:06 PM
  7. [SOLVED] Highlighted Cell
    By Dave in forum Excel General
    Replies: 1
    Last Post: 05-01-2005, 01:06 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