Libre Office conditional formatting tutorial


(Click image above to watch video 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 formatting and sell colouring based on specified conditions. For examples if a column contained 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.

Once you have finished viewing this tutorial then why not check out some of our other free Libre Office video tutorials!


Get our weekly FREE tips and video tutorials straight to your inbox and start growing your business today!

Subscribe to FREE newsletter!

    Your comment was added successfully, is waiting for acceptation

    Get Your Quote Today!

    Newsletter Subscription

    Subscribe to our newsletter to receive an e-mail once a month with our latest video tutorials, blog articles and web design special offers!


    Follow Us

    Are you using any of the popular social networks such as Google+, You Tube, Twitter, Facebook or LinkedIn? Add us to your Social Network account and get special offers exclusive to our Social Network Followers!

    back to top