Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Friday, March 20, 2015 – Permalink – Conditional FormattingIf it's Tuesday, it must be mauveConditional formatting is one of Excel's better features. It allows you to preset certain font styles, colors, and cell-background colors based on cell values. This can be very useful for highlighting important information and values outside an accepted range or providing a visual cue to associate value ranges with color codes. The best part is that conditional formatting is very easy to set up. Just click the cells you'd like to format and select Format >Conditional Formatting. The Conditional Formatting dialog box lets you set up the conditions by which the formatting of the cell will occur. You pick the operator (between, equal to, less than, etc.) and the value or range of values. Click Format to open the Format Cells dialog box, where you can select the colors and styles to be used. Each cell can have several conditional formats. For example, you might say that if a certain cell's value is between 20 and 50, the text should be blue on a yellow background. However, you can format that same cell to exhibit red, bolded text on a green background if it contains a value between 51 and 100. Before 2007, you could use up to three conditions, but earlier versions of Excel can be tricked to use more if it should become necessary. Oz Grid: Excel VBA Macro Code to Get Around Excel's 3 Criteria Limit in Conditional Formatting GR Business Process Solutions: Graham Barrow and Ray BlakeHighlight the current or past month in Excel with conditional formatting Chip Pearson: Conditional Formatting Also: Adding Customized Rules to Excel 2007 Demo: Data takes shape with conditional formatting See all Topics excel Labels: Customize, Formats, General, Reference, Tips, Tutorials <Doug Klippert@ 3:48 AM
Comments:
Post a Comment
|