 |
 | 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 / New Users / May 2008Conditional formatting in Excel 2007
i have a worksheet with a list of prospects. I want the row to be conditionally formatted when a change one cell to "quote". i can get that particular cell to change, but i want it for the whole row! Can anyone help?  SignatureBrad Let's assume you want to highlight the range A1:E1 if E1 = quote. Select the range A1:E1 Goto Home tab>Styles>Conditional Formatting>New Rule>Use a formula to determine....... Enter this formula: =$E1="quote" Click the Format button Select the desired style(s) OK out SignatureBiff Microsoft Excel MVP >i have a worksheet with a list of prospects. I want the row to be > conditionally formatted when a change one cell to "quote". i can get that > particular cell to change, but i want it for the whole row! > > Can anyone help? Cheers - all sorted SignatureBrad > Let's assume you want to highlight the range A1:E1 if E1 = quote. > [quoted text clipped - 16 lines] > > > > Can anyone help? You're welcome! SignatureBiff Microsoft Excel MVP > Cheers - all sorted > [quoted text clipped - 19 lines] >> > >> > Can anyone help? |
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
|
©2008 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.