Results 1 to 9 of 9

Count cells in row based on cell value, highlight row if wrong number or cells.

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2014
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    47

    Count cells in row based on cell value, highlight row if wrong number or cells.

    I want to have a macro that checks the letters in column E and counts the cells in the row, and if the number does not match a preset for those letters combinations the row gets highlighted red.
    In the example attached, row 2 has BLD the column E, so that row should have a total of 7 columns filled out.
    So:
    CP needs 5 count
    BLD needs 7 count
    ED needs 6 count
    TBKR needs 0 count
    And so on…

    I will need to be able to add additional lines of code to the macro to check the more than 150 letter combinations.
    Any help would be appreciated.


    SampleRESULT.xlsxSample.xlsx
    Last edited by gutterball; 09-09-2014 at 04:25 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] highlight a series of cells based on the number of days in a date range
    By b2lynch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2014, 10:48 PM
  2. [SOLVED] Highlight Cells based on Cell Reference on another Worksheet
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-28-2014, 08:24 AM
  3. highlight specific cells in row based on one cell value in same row.
    By mgbanc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2013, 06:58 AM
  4. Highlight 1 cell based on value from other cells
    By freeon in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-10-2013, 01:24 PM
  5. Highlight or colour a cell or cells based on cells in another range.
    By baffld in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2012, 08:41 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