+ Reply to Thread
Results 1 to 3 of 3

Highlight column range based on multiple cell string match

  1. #1
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    365
    Posts
    167

    Highlight column range based on multiple cell string match

    Hi,

    Thanks to MickG in another post here
    https://www.excelforum.com/excel-pro...g-in-cell.html
    He solved my original question.

    I have decided to open a new post as my question has evolved as my workbook develops and I don't want to waste peoples time changing my mind all the time.

    Sample attached shows column L with 5 inputs in rows 6 onward. The macro buttons named Errors & ClearCSV run the report and clear the report.

    Clicking Errors and running report shows cells in column L turn red, this is where the TCN reference and A reference don't equal 5 & 10 digits respectively. This works as I originally requested so fair play to MickG.

    What I have since realised is that if only one of the reference numbers is present then it doesn't highlight red.

    What I am now looking for... and this is an ongoing project so you will probably see it again.

    Highlights red when TCN and/or A references don't equal 5 & 10 digits respectively, highlights red if only one ref is present but incorrect, and highlights green if both are present and match 5 & 10 digits respectively.

    Also if it could highlight the row from A:L rather than just L

    I hope that makes sense.

    Regards
    Tez
    Attached Files Attached Files
    Last edited by ~TaC~; 08-21-2019 at 10:59 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,694

    Re: Highlight column range based on multiple cell string match

    No sample attached...

  3. #3
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    365
    Posts
    167

    Re: Highlight column range based on multiple cell string match

    Sorry, sample now attached.

+ 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. [SOLVED] Highlight row based on text within string in cell
    By ~TaC~ in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-19-2019, 05:48 PM
  2. Replies: 1
    Last Post: 07-14-2015, 06:46 AM
  3. Attempting to Highlight Cells Based on String within Cell
    By rmdlp in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-23-2014, 04:30 PM
  4. [SOLVED] Help using VBA to highlight a partial column based on text in a cell out of the range
    By JTKEXCEL in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-20-2013, 04:46 AM
  5. Replies: 2
    Last Post: 12-12-2012, 04:19 AM
  6. [SOLVED] Highlight row based on character/text string containing in cell.
    By dihris in forum Excel General
    Replies: 2
    Last Post: 12-03-2012, 11:16 AM

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