 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2005Conditional Formatting
Hi, I am trying to write a condition if one cell meets the condition (Example H5 = OPEN) then turn cells H1 through O1 to red (Color fill) If H5 = Closed then turn Cells H1 through O1 to Green Is this something I can do in Excel? Any help would be greatly appreciated. Thanks Format>Conditional Formatting under this you can define a formula referring to the cell H5="open" and define the conditional formats. You can specify upto 3 different conditions and you can also specify them within a formula, such as an if function > Hi, > [quoted text clipped - 7 lines] > > Thanks I understand how to format one cell, I'm just not sure how to format multilple cells within one row based on whats in that one cell. What I want to see is if h5="open" the color fill h1 through o1 with RED... > Format>Conditional Formatting under this you can define a formula referring > to the cell H5="open" and define the conditional formats. You can specify [quoted text clipped - 12 lines] > > > > Thanks I also want to repeat this formatting in multiple rows.. Thanks Much! > I understand how to format one cell, I'm just not sure how to format > multilple cells within one row based on whats in that one cell. [quoted text clipped - 17 lines] > > > > > > Thanks Figured it out... Thanks for your help was much appreciated!! > Hi, > [quoted text clipped - 7 lines] > > Thanks Kimberly Yes, through Conditional Formatting. Select H1:O1 and Format>Conditional Formatting>Condition 1>Formula is: =$H$5="OPEN" Format to Red Pattern Hit "Add" button to set Condition 2 Condition 2>Formula is: =$H$5="Closed" Format to Green Pattern Gord Dibben Excel MVP >Hi, > [quoted text clipped - 7 lines] > >Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.