openoffice conditional formatting greater than less than

A conditional format that highlights cells that contain the word YES in green and the word NO in red, has been applied to the Pass column:Ĭonditional formatting is a replacement for manually finding and formatting individual cells or groups of cells and also automatically adapts to any changes made to the contents of a cell. A conditional formatting rule that displays amounts lower than $15,000 in red font and amounts higher than $15,000 in blue font, has been applied to the Salary column. Conditional formatting is a great timesaving tool that ensures consistency and accuracy in formatting data using the same formatting rules. If you apply conditional formatting to an entire worksheet, the rule will continue to be applied to data that you add or change on the worksheet. You can create conditional formatting rules for just about any condition. You can, for example, decide that all cells containing the word YES must be formatted with green font and all cells containing the word NO, should be formatted in red font. It allows you to quickly create a visual analysis of a worksheet by applying formatting to specified cells based on their contents. Test your Excel skills with the corresponding FREE Online Multiple ChoiceĬonditional formatting is arguably one of Excel’s most useful and fun features. This can help you focus on what’s really important.

all cells over $5000 or the top 10 items or all of the cells within a date range. You can apply different formatting to a cell or cells that meet your specific conditions i.e. Free Excel Tutorial – Conditional Formatting – Excel 2010 Training Conditional Formatting Excel Tutorialįree Online Microsoft Excel Tutorial * What is Conditional Formatting?Ĭonditional Formatting lets you highlight data.

Openoffice conditional formatting greater than less than