+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting To Reference a String in a Column and Applied to another Column

  1. 02-21-2014, 04:20 PM #1
    ABC2014 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    america
    MS-Off Ver
    ABCD
    Posts
    2

    Unhappy Conditional Formatting To Reference a String in a Column and Applied to another Column

    Dear Group,

    I am a new member. I joined to ask this question about conditional formatting. Please pardon any novice behavior on my part.

    Goal:

    If a string value appears anywhere column A, such as "Home",

    Highlight whatever is in the respective cell within the target column of the conditional format. Just the one which is in the same row containing "Home"


    Here is a crude diagram:

    COL A COL B

    X_______________not highlighted because COL A not containing HOME
    HOME____________highlighted using conditional formatting
    X_______________not highlighted because COL A not containing HOME


    Tried this with countif, and if, to no avail. The best I could get it to do is highlight all the cells, not just the "target" cell.

    I would be so thankful for help with this specific case because I have worked the internet with 0 results for this. Please, experts, any help is appreciated.
    Reply With QuoteRegister To Reply
  2. 02-21-2014, 04:41 PM #2
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,655

    Re: Conditional Formatting To Reference a String in a Column and Applied to another Column

    See the attached example workbook.


    Regards, TMS
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-21-2014, 04:43 PM #3
    ben_hensel is offline
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Conditional Formatting To Reference a String in a Column and Applied to another Column

    Conditional formatting with a formula

    In B1 apply this rule:
    =A1="HOME"

    Apply rule to range (eg, B1:B100)

    That should do it. (Well, it's not case sensitive).

    See attached.


    EDIT:
    Looks like TMS interpreted the premise differently than me? Well the basic principle is the same, although looking at what TMS did, that's more slick than mine.
    Attached Files Attached Files
    Last edited by ben_hensel; 02-21-2014 at 04:46 PM.
    Reply With QuoteRegister To Reply
  4. 02-21-2014, 04:50 PM #4
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,655

    Re: Conditional Formatting To Reference a String in a Column and Applied to another Column

    Adding Ben's suggestion for column B but still using an external cell for the string.

    See attached

    Regards, TMS
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 02-21-2014, 07:56 PM #5
    ABC2014 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    america
    MS-Off Ver
    ABCD
    Posts
    2

    Re: Conditional Formatting To Reference a String in a Column and Applied to another Column

    You all are so enthusiastic and helpful. Please accept my sincerest gratitude for your time and effort. I really wish to thank you, and will dive into the multiple assistance replies here. Thanks again!!

    ben_hensel had the most aligned answer with what I am searching for.

    That is, if Home is in column A, and any other value in column B, highlight column B. In other words, column B might not have home in it but if A does I am trying to highlight column B. This is perfect, and thank you all.
    Last edited by ABC2014; 02-21-2014 at 08:06 PM.
    Reply With QuoteRegister To Reply
  6. 02-21-2014, 08:25 PM #6
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,655

    Re: Conditional Formatting To Reference a String in a Column and Applied to another Column

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting multiple column based on reference cell???
    By inincubus in forum Excel General
    Replies: 2
    Last Post: 01-23-2014, 04:04 PM
  2. [SOLVED] Find average of column b based on boundaries applied to column a
    By Kybynn in forum Excel General
    Replies: 1
    Last Post: 12-04-2012, 07:17 AM
  3. conditional formatting formula, to highlight cells in column b, based on dates in column a
    By dickman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  4. [SOLVED] column to column conditional formatting won't work, need formula
    By rrupp in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  5. [SOLVED] Conditional Formatting, reference another column
    By DavidL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2005, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1