Results 1 to 6 of 6

Conditional Format Based on specific text in 3 different cells

Threaded View

tradersteve Conditional Format Based on... 10-07-2010, 10:57 PM
mdbct Re: Conditional Format Based... 10-07-2010, 11:33 PM
tradersteve Re: Conditional Format Based... 10-08-2010, 02:18 AM
mdbct Re: Conditional Format Based... 10-08-2010, 06:41 AM
tradersteve Re: Conditional Format Based... 10-09-2010, 01:22 PM
NicParham Re: Conditional Format Based... 11-08-2011, 06:49 AM
  1. #1
    Registered User
    Join Date
    07-25-2010
    Location
    Blue Springs, MO
    MS-Off Ver
    Excel 2007
    Posts
    22

    Thumbs up Conditional Format Based on specific text in 3 different cells

    I have the following code to fill Y2 based on the text in L2 or M2

    =OR($L1="g",$M1="g")
    I would like to add to the formula so that it would only trigger IF the text in C2 which is normally a number followed by a space and then a single letter (ex.= 23 A), has either "rt" or "rs" at the end. (ex. = 23 A rt)

    Is this too many conditions to nest within regular conditional formatting?

    Any help with this or an alternative formula would be greatly appreciated!

    Thanks
    Last edited by tradersteve; 10-09-2010 at 01:24 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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