Results 1 to 4 of 4

conditional match first 2 letters of 3 cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-15-2010
    Location
    Oklahoma
    MS-Off Ver
    Excel 2019
    Posts
    168

    Question conditional match first 2 letters of 3 cells

    What would be a conditional format formula that would return a result based on 3 cells in a row of 10 cells all having the same first 2 identical letters? Example, if the words in the 3 cells all start with EV, the whole row would stay unaffected, but if one of the 3 cells had a word that began with something different, say EE, then the row would be highlighted in red. I have figured out how to match two, but cannot get three. I appreciate your consideration, Gary
    Last edited by allgeef; 03-22-2011 at 11:27 AM.

Thread Information

Users Browsing this Thread

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

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