I selected the range B4:I18 and went to Format > Conditional formatting > Condition and added a condition 'If cell value is equal to 'Y' apply style 'Yesresult'' and similarly for 'N'. Once the cells are selected, hit ENTER and your average will appear. In the Styles and formatting dialog (F11) I added 2 new styles from selecting those cells individually. You type this into the cell you want the average to appear and, with the cursor between the parentheses, select the cells containing the values you wish to average. The command to for Open Office to calculate average is =AVERAGE( ). Is average a function in Libreoffice Calc? The selected cells are now formatted in the relevant style. On the Conditional Formatting dialog, enter the conditions.What is the difference between auto format and conditional format Conditional formatting permits you to automatically apply formattingsuch as colors, icons, and data bars. Choose Format > Conditional Formatting from the menu bar. Using this tool you can automatically apply formatting such as colors, icons, and data bars, to a range of cells based on a condition or cell value.In your spreadsheet, select the cells to which you want to apply conditional formatting.As for 'Conditional Formatting' it is a bit more different bcause I accidentally attached a version edited and saved from LibreOffice V 4.3.5 containing a newer feature, the CF manager.
![openoffice conditional formatting bars openoffice conditional formatting bars](http://www.openoffice.org/documentation/HOW_TO/spreadsheet/sty4_bis.gif)
How do you do conditional formatting in LibreOffice Calc? The difference in the view of 'Styles and Formatting' should be nearly invisible (the icons only).
![openoffice conditional formatting bars openoffice conditional formatting bars](https://usermanual.wiki/Openoffice-Org/OpenofficeOrgOpenoffice33CalcGuide777746.1453241595/asset-17.png)
#OPENOFFICE CONDITIONAL FORMATTING BARS CODE#
Alternatively, once you know the hexadecimal code of the character, type in your text U+2713 followed by Alt + X (simultaneous press of both keys) for U+2713 CHECK MARK. You can know choose the mark you prefer and Insert it.