Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Column C is a column of text that is comprised of 2 other columns (A & B) of text combined by the following formula, for example: A1&" to "&B1. Column C could be as long as 2500 rows, or as short as 25 rows. The text in columns A & B could be as short a 1 word or as long a 5 words, with each word from 2 to 15 letters each. What I would like to do in Column C is wherever a certain word or words appear before or after the "to", i. e., the words from the respective cell in column A or B, I would like to highlight that cell (in Column C) in, say, yellow. For example, if the result in C3 is "Jim Bob to Mary Louise Smith", and I wanted to highlight C3 if "Jim Bob" is present before the "to", C3 would be highlighted. In the alternative, if the result in C4 is "Elvis to Mary Anne Smith", and I wanted to highlight the cell if Mary Anne Smith was present after the "to", the cell would be highlighted. Any ideas?
    Thanks in advance.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Try the attached "Conditional Formatting". It always uses Yellow for highlight, any other colors can be used.
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Tim. Actually, I meant to shade the cell in yellow, not to change the color of the text. Any ideas?

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Try this ...
    Attached Files Attached Files

  5. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Here is another idea ..... Change Cell E2 or F2 be the name you want highlighted in Col C. For example try changing E2 to Elvis and see the changes in Col C.
    Attached Files Attached Files

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Tim. One further question: can we insert "or" argumants into the conditional formatting arguments? For example, if A2=either Elvis or Jim Bob, but B2 didn't equal Mary Anne Smith, could we shade the cell?
    Thanks again

  7. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by jlkirk View Post
    Thanks Tim. One further question: can we insert "or" argumants into the conditional formatting arguments? For example, if A2=either Elvis or Jim Bob, but B2 didn't equal Mary Anne Smith, could we shade the cell?
    Thanks again
    Hello jlkirk - Will this do what is needed?
    Attached Files Attached Files

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Tim, works great!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •