Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Conditional formatting of text cells

  1. #1
    New Member
    Join Date
    Jan 2002
    Location
    Victoria BC
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Fabulous Site! I've learned tons while looking to solve these 2 similar problems: 1. Using conditional formatting I would like to highlite cells in a range containing specific text (within text), and 2. again using conditional formatting I would like to highlite cells in a row that have more than one occurrence of the same specific text (within text). Seperate issues. This is a baseball schedule containing team references in the cells ie: "A1 vs B3", "C6 vs A2" etc, I am trying to highlight cells containing a specific team in a range of cells ie: "A2" for question 1, and highlight multiple occurrences of cells containing "A2" in a row for question 2.
    Very much appreciated and again - fabulous site!

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,656
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-01-14 12:52, Terry M wrote:
    Fabulous Site! I've learned tons while looking to solve these 2 similar problems: 1. Using conditional formatting I would like to highlite cells in a range containing specific text (within text), and 2. again using conditional formatting I would like to highlite cells in a row that have more than one occurrence of the same specific text (within text). Seperate issues. This is a baseball schedule containing team references in the cells ie: "A1 vs B3", "C6 vs A2" etc, I am trying to highlight cells containing a specific team in a range of cells ie: "A2" for question 1, and highlight multiple occurrences of cells containing "A2" in a row for question 2.
    Very much appreciated and again - fabulous site!
    You mean to highlite each cell that contains the team A2? If so, select the target range, activate Conditional Formatting, choose Formula Is for Condition 1, enter as formula (assuming that your range E2:H60),

    =COUNTIF(E2,"*A2*")

    activate Format, select a color on the Patterns tab, click OK twice.

    Note: I can't see your post listed. I arrived here by using the Search facility, not an easy way of interaction.



    [ This Message was edited by: Aladin Akyurek on 2002-01-14 13:38 ]

    [ This Message was edited by: Aladin Akyurek on 2002-04-15 08:43 ]

  3. #3
    New Member
    Join Date
    Jan 2002
    Location
    Victoria BC
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks very much. It's often an easy solution - I was trying formulas much more complex than that - but your basic one works well!

    I have no idea why my post isn't viewable. I'm new on the board as you can see. I did notice that when I posted it the date was several months out of whack.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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