Conditional Formatting - Libre Office Tutorial

Libre Office contains some useful features and in this tutorial will look at conditional formatting. Conditional formatting simply allows you to change the content or style of a spreadsheet cell based on specific conditions you create. There are various types of conditional formatting which can be used and the type used depends on the content of your spreadsheet cells.

Conditional formatting types:

General condition
Colour scale
Data bar
Icon set
Date

Listed above are the main types of conditional formatting which can be used Libre Office. At DCP we mainly use conditional formatting to quickly apply to cells, colouring based on specified conditions. For examples, if a column containing a list of prices we can apply a formatting condition which changes the colour of a cell to red if the price less than £100.00 or change the colour of a cell to green if the price is greater than £200.00. This is a basic example of conditional formatting but if you view the video tutorial above you can see some more useful examples.

Not familiar with open office Calc? - Check out of free extensive tutorial here: https://www.dcpweb.co.uk/blog/libre-office-calc-spreadsheet-beginners-tutorial

Subscribe to access 500+ video tutorials: https://www.youtube.com/dcpwebdesigners

#LibreOffice #Calc #dcpweb

Contact me on:

Instagram: https://www.instagram.com/dcp_web_designers/
Facebook: https://www.facebook.com/dcpwebdesigners/
Pinterest: https://www.pinterest.co.uk/dcpwebdesigners/
LinkedIn: https://www.linkedin.com/in/dcpwebdesigners/

Free tutorials, infographics, articles: https://www.dcpweb.co.uk/blog

conditional formatting in libre calc, conditional formatting libre calc, libre calc conditional formatting, libre calc conditional formatting formula, libre conditional formatting, conditional formatting libreoffice calc, libreoffice calc conditional formatting background color, libreoffice calc conditional formatting color, conditional formatting libreoffice, calc conditional formatting, libreoffice calc conditional formatting, conditional formatting using libre calc