Results 1 to 6 of 6

Conditional Formatting based on multiple strings in multiple cells

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2013
    Location
    Del Rio,TX
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Conditional Formatting based on multiple strings in multiple cells

    Hi,

    I'm trying to find a formula that would change the color of one cell based on multiple words found in a row. For example A1 would turn red if any cell from A2:H2 contains any of the following anywhere in the cell "BKN001,"1/4","TS","35" etc... Your help is appreciated.
    Attached Files Attached Files

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