Results 1 to 23 of 23

highlight when specific text appears multiple times in a range of cells - excel 2013

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2013
    Location
    Salt Lake City
    MS-Off Ver
    Excel 2013
    Posts
    20

    highlight when specific text appears multiple times in a range of cells - excel 2013

    Ok guys, this is my goal. I know you all can help.

    Disciplinary action worksheet.

    I have to add violations to this worksheet every time my associate gets a violation.

    If the associate reaches x number of violations, they will receive disciplinary action.

    Example:

    2x (2 instances) of "2.6B Call Documentation" = Highlight Yellow
    3x (2 instances) of "2.6B Call Documentation" = Highlight Red

    I would like to have a area/set/range of cells designated for these rules such as A1:A27. As i go down this list and enter items, if the specific text appears multiple times, the cell will highlight advising of a needed action based off the color.

    Should I create a drop down so the desired text is the same every time and I or one of my colleagues can't accidentally put "2.6 Call Documentation"?

    Please note that there are about 50 violations and they each carry their own weight. Some call for disciplinary action at 2 instances, some don't call for a disciplinary action until 12 instances.

    From the looks of it, you all are genius. I will check this daily. It will be awesome when you figure it out and at that time I will bow before your greatness!. So excited I found this website!
    Last edited by Onefynebarraza; 10-10-2013 at 12:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2010 show how many times each text appears
    By umen in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 01-23-2013, 03:57 PM
  2. Count number a times a specific value appears consecutively.
    By kww0027 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2013, 06:17 PM
  3. [SOLVED] How to highlight (not count) a word that appears in an Excel Worksheet multiple times
    By rmason in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-01-2012, 08:43 AM
  4. Count the number of times a specific text appears in column D
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2011, 02:02 PM
  5. [SOLVED] Count names-how many times a specific name appears
    By Farrel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2005, 04:05 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