+ Reply to Thread
Results 1 to 2 of 2

Thread: Conditional formatting to for row

  1. 02-04-2012, 08:02 PM #1
    vietdieu
    vietdieu is offline
    Registered User
    Join Date
    01-13-2012
    Location
    SLD
    MS-Off Ver
    Excel 2010
    Posts
    49

    Conditional formatting to for row

    Hi all,
    I'm not sure how to hightlight a row if it contain a specific text. I have a big table, in a col, at any row if it appear a specific item I want to highlight that row. Eg, table of A3:Z50. The item list is at col D. If item "Vehicle" is in D40 then I want that row A40:Z40 is highlight.
    Tks for your help!
    Reply With Quote Reply With Quote
  2. 02-05-2012, 12:07 AM #2
    dilipandey
    dilipandey is offline
    Valued Forum Contributor dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    New Delhi, India
    MS-Off Ver
    Excel 1997, 2000, XP, 2003, 2007, 2010
    Posts
    2,398
    Send a message via ICQ to dilipandey Send a message via AIM to dilipandey Send a message via MSN to dilipandey Send a message via Yahoo to dilipandey Send a message via Skype™ to dilipandey

    Re: Conditional formatting to for row

    Hi vietdieu,

    See the attached file and try entering Vehicle in column D. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files
    DILIPandey
    +919810929744
    dilipandey@gmail.com
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0