+ Reply to Thread
Results 1 to 2 of 2

Thread: Conditional Formatting

  1. 10-31-2011, 06:44 AM #1
    sushil10s
    sushil10s is offline
    Registered User
    Join Date
    10-28-2011
    Location
    Delhi
    MS-Off Ver
    Excel 2007
    Posts
    86

    Conditional Formatting

    Hi,

    Attached is an excel file with a table and used is the data validation in Columns E, F and H. Kindly provide a way to change the color (e.g, green) of entire row in the table if selected "Approved" from the drop down list (Column E).

    [First time user...Please ignore mistake(s) and/or lack of sufficient details (if there are)]

    Thanks
    Sushil
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 10-31-2011, 06:48 AM #2
    arthurbr
    arthurbr is offline
    Extremely Helpful member
    Join Date
    12-23-2006
    Location
    Belgium
    MS-Off Ver
    XL2003
    Posts
    6,127

    Re: Conditional Formatting

    Select range E5:H14 and use 
    =$E5="approved"
    as formula for the CF
    Quoting entire posts clutters the forum and makes threads hard to read !

    If you are pleased with a member's answer then use the Star icon to rate it

    Click here to see forum rules
    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)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0