![openoffice conditional formatting highlight duplicates openoffice conditional formatting highlight duplicates](https://mitacademys.com/wp-content/uploads/2021/12/Screenshot-from-2021-12-25-18-33-59.png)
Select the format you want from the drop-down list.As soon as you have entered the value, Microsoft Excel will highlight the cells in the selected range that meet your condition. Enter the value in box in the right-hand part of the window under " Format cells that are LESS THAN", in our case we type 0.Highlight text containing specified words or characters.Format values greater than, less than or equal to.Of course, you can go ahead with any other rule type that is more appropriate for your data, such as: Since we need to apply conditional formatting only to the numbers less than 0, we choose Highlight Cells Rules > Less Than.You will see a number of different formatting rules, including data bars, color scales and icon sets.
![openoffice conditional formatting highlight duplicates openoffice conditional formatting highlight duplicates](http://datacandy.github.io/warwick/dataclean/clean4.png)
Go to the Home tab > Styles group and click Conditional Formatting.all cells with negative numbers in the Change column, so we select the cells C2:C9. What we want is to highlight every drop in price, i.e. In your Excel spreadsheet, select the cells you want to format.įor this example, I've created a small table listing the monthly crude oil prices.However, the options are essentially the same in all Excel versions, so you won't have any problems with following no matter which version is installed on your computer.
![openoffice conditional formatting highlight duplicates openoffice conditional formatting highlight duplicates](https://i.stack.imgur.com/4kfT3.png)
#OPENOFFICE CONDITIONAL FORMATTING HIGHLIGHT DUPLICATES HOW TO#
I will show you how to apply conditional formatting in Excel 2010 because this seems to be the most popular version these days.