Results 1 to 3 of 3

condition formatting for list of values from key values of appropriate match

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    condition formatting for list of values from key values of appropriate match

    dear experts

    help on my post

    i have set of list values in column b and c in column b contains full lenght of text and column c have short cut keys for a cell values

    i want apply condition formatting for particular column from short cut keys column c

    e.g 1i have short letter 24/7 in keylist result in H:H columns any where appear( 24/7 Customer or Customer 24/7 )
    i want make the cell color.
    ONE MORE E.G
    IF TATA M In the list keys if any words comes like TATA MOTORS OR TATA MOPHED MAP COLOR

    thanks alot

    find the attachment you may understand easily.......
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cell condition not accept values other than list of value
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-24-2013, 01:39 PM
  2. [SOLVED] Match up 2 lines to their values in a table and check condition.
    By stockgoblin42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-26-2013, 10:52 AM
  3. Replies: 4
    Last Post: 06-13-2012, 05:44 AM
  4. Function to match random list values to set list values.
    By Sandman4432 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2007, 09:22 PM
  5. List valid values if a condition
    By Markswife3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2005, 02:06 AM

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