![openoffice conditional formatting based on another cell openoffice conditional formatting based on another cell](https://s3.manualzz.com/store/data/036761572_1-e948e6b4253411b7554041bddf9a8a76.png)
![openoffice conditional formatting based on another cell openoffice conditional formatting based on another cell](https://img.brainkart.com/imagebk37/bazHZNF.jpg)
New Rule: Enables you to specify other conditional formatting rules, including rules based on a logical formula.Icon Sets: Displays icons directly in the cells.Color Scales: Applies background color, proportional to the cell’s value.
![openoffice conditional formatting based on another cell openoffice conditional formatting based on another cell](https://media.cheggcdn.com/media%2Ff8a%2Ff8aeebed-3e04-4979-b141-71bdc3678bb7%2FphpltyCZi.png)
Data Bars: Applies graphic bars directly in the cells, proportional to the cell’s value.Top Bottom Rules: Examples include highlighting the top 10 items, the items in the bottom 20 percent, and items that are above average.Highlight Cell Rules: Examples rules include highlighting cells that are greater than a particular value, between two values, contain specific text string, a date, or are duplicated.To apply a conditional formatting rule to a cell or range, select the cells and then use one of the commands from the Home Styles Conditional Formatting drop-down list to specify a rule. Above average: Values that are higher than the average value are highlighted.Ĭhapter 20: Visualizing Data Using Conditional Formatting Specifying Conditional Formatting.This rule is just one of many numeric value related rules that you can apply. Greater than 10: Values greater than 10 are highlighted with a different background color.You can use a format (such as bright-red cell shading) to make particular cells easy to identify.įigure 20.1 shows a worksheet with nine ranges, each with a different type of conditional formatting rule applied. If not, no formatting is applied.Ĭonditional formatting is a useful way to quickly identify erroneous cell entries or cells of a particular type. If the value is negative, the background is shaded. When you enter or change a value in the range, Excel examines the value and checks the conditional formatting rules for the cell. For example, you can set things up so that all negative values in a range have a light-yellow background color. About Conditional FormattingĬonditional formatting enables you to apply cell formatting selectively and automatically, based on the contents of the cells. You’ll find a few more conditional formatting improvements in Excel 2010. Microsoft made significant enhancements to conditional formatting in Excel 2007, and it’s now a useful tool for visualizing numeric data. You can apply conditional formatting to a cell so that the cell looks different, depending on its contents. This chapter explores conditional formatting, one of Excel’s most versatile features.
![openoffice conditional formatting based on another cell openoffice conditional formatting based on another cell](https://i.stack.imgur.com/mQajU.png)
Reviewing the Available ActiveX Controls.Understanding the Different Web Formats.Working with External Reference Formulas.Using Formulas for Data Validation Rules.Types of Validation Criteria You Can Apply.Displaying a Sparkline for a Dynamic Range.User Interface Choices for Modifying Chart Elements.Understanding the Dimensions of an Array.Conditional Sums Using Multiple Criteria.Conditional Sums Using a Single Criterion.Creating Custom Views of Your Worksheet.Preventing Certain Cells from Being Printed.Copying Page Setup Settings across Sheets.Adding a Header or Footer to Your Reports.Using Named Styles for Easier Formatting.Adding a Background Image to a Worksheet.Entering Dates and Times into Your Worksheets.Entering Text and Values into Your Worksheets.