

Pcmag.com $(document).ready(function() { $('.search-box').focus(function() { $(this).attr('value', '') .css('color', '#000'); }); $('.search-box').blur(function() { var searchContents = $(this).attr('value'); if (searchContents == '' && searchContents != 'SEARCH') { $(this).attr('value', 'SEARCH') .css('color', '#ccc'); } }); }); HomeTipsOffice AppsMicrosoft ExcelConditional Formatting in Excel Conditional Formatting in Excel email share print reprint Share this page Social Sharing Sponsored by: By: Neil J. Rubenking12.01.20090 comments Excel's conditional formatting (Format | Conditional Formatting in Excel 2003 or the Conditional Formatting button on the Home ribbon in Excel 2007) can make spreadsheets a lot easier to interpret?changing the text color in a cell, for example, if a given condition is true. There are times when you may want to go beyond the basics as given in Excel's help file, however. In particular, you may want the format to apply only if two conditions are true?if cell A1 is "yes" and cell A2 is "no" for example. It's not obvious how you might do that, but it's easy once you know how. Set the Condition in Excel 2003 to Formula Is, or create a rule using a formula in Excel 2007, and set the formula to =AND(condition 1, condition 2). In this example, the actual formula would read: =AND(A1="yes", A2="no").
More... Recommended More by this Author Stuxnet: Cyber Attack on Iranian Nuclear Reactors? PC Tools Internet Security 2011 Comodo Challenges Symantec to Antivirus Showdown ZoneAlarm Terminates Misleading ZeuS.Zbot Alert F-Secure Internet Security 2011
.dsq-global-toolbar-container { display:none; } 246444http://www.pcmag.com/article2/0,2817,2356457,00.aspqr0AM0vA3N965TwszpPEvjVWvidaKmvlW9tyDPw2k5Q=5133110T0 Comments Add Your Comment 2000 characters remaining
#w_graveyard {clear:none!important;}SponsorsPCMag's SMB Innovators: Small Businesses Doing Smart Things with Technology. Sponsored by Verizon Wireless.Google Chrome Download. Searching is fast and easy with Google's web browser. www.google.com/chromeCrucial memory is an affordable, effective way to boost PC performanceGet the business phone service that gives you more: Internet fax, online meetings, call recording and softphone.Optimize 802.11n performance with Cisco CleanAir technology. Learn How.Boost productivity with cutting edge computers from HP and AMD.Ultimate wireless performance to power your life. Linksys E-Series.New Dell LED Studio monitor starting at $159.99! Beautiful Screen Quality and Slim design! LogMeIn Free ? Remote Support has never been faster, easier or freer.Protect your Family PC, identity, photos, & music from online digital dangers. Download a FREE 60-Day Trial of Norton Internet Security 2011 right HERE!Adobe® eLearning Suite 2 ? A complete eLearning authoring toolbox.Brother Printers Rated #1 in Reliability. Learn More at Brother.com.Make meetings more efficient with MindManager - start your free trialSave now with the best deals from CDW. Save on desktops, notebooks, LCDs and more.Spyware Doctor with AntiVirus 2010: Top scorer in PCMag's malware-removal and malware-blocking tests. Safeguard your PC now.Upgrade today with new laptops and desktops from HP and Intel.Save up to $300 on select best-selling Dell laptops!Save up to $375 on select Dell performance laptops with Core i7 technology!Save up to $500 on select Dell performance desktops with Core i7 technology! .premium_partner_link {display:block; width:80px; height:40px; line-height:36px; border-top: 1px #828282 solid; border-right: 1px #828282 solid; border-bottom: 3px #828282 solid; border-left: 3px #828282 solid; text-decoration:none!important;}.premium_partner_link_double {display:block; width:80px; height:40px; line-height:17px; border-top: 1px #828282 solid; border-right: 1px #828282 solid; border-bottom: 3px #828282 solid; border-left: 3px #828282 solid; text-decoration:none!important;}.premium_partner_link:hover {background-color:#e0f3f7; border-top: 3px #828282 solid; border-right: 3px #828282 solid; border-bottom: 1px #828282 solid; border-left: 1px #828282 solid; text-decoration:none!important;}.premium_partner_link_double:hover {background-color:#e0f3f7; border-top: 3px #828282 solid; border-right: 3px #828282 solid; border-bottom: 1px #828282 solid; border-left: 1px #828282 solid; text-decoration:none!important;}.premium_partner_title {font-weight: bold; font-size: 11px; color:#117398; font-family: Arial, Helvetica, sans-serif; font-weight:bold; text-align: center; padding:2px;}.premium_partner_button {float:left; margin:3px; text-align:center;}.premium_margin {margin:14px 0px 0px 5px;}.partners {border:0px; padding:6px 8px 15px 10px;}div#content div.partners {border:10px solid #E9E9E9;}div#content div.partners .premium_partner_button {margin:7px;}div#content div.premium_margin {margin: 15px 0px 0px 0px;}Shop for products from our partnersCDWDell HomeHP Home & Home OfficeIntel Lenovo .spotlight .frame {height:auto!important;} ADVERTISEMENTProduct Spotlight
HP Mini 5103The HP Mini 5103 comes fully-loaded with a dual-core Atom processor, Broadcom HD decoder chip, and touchscreen.
Editor Rating
Spyware Doctor with AntiVirus 2010Spyware Doctor with AntiVirus 2010 adds numerous new "guards" against malware and promises enhanced malware detection and cleanup?and delivers.
Editor Rating
PC MAGAZINE DIGITAL EDITION
Issue Index Customer Service Subscribe
Use of this site is governed by our Terms of Use and Privacy Policy
Copyright © 1996-2010 Ziff Davis, Inc. All Rights Reserved. PC Magazine is a registered trademark of Ziff Davis, Inc. Reproduction in whole or in part in any form or medium without express written permission of Ziff Davis, Inc. is prohibited.

No comments:
Post a Comment