Libre Office conditional formatting tutorial

Back

26-09-2017

(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 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.

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

Subscribe to DCP YouTube for free Libre Office Calc video tutorials.

# conditional formatting in libre calc

# conditional formatting LibreOffice

# LibreOffice calc conditional formatting colour

# conditional formatting libre calc


Conditional formatting LibreOffice calc video tutorial created by: DCP Web Design in London


Releated Posts

How to split data into separate columns using Microsoft Excel

25-09-2017

How to split data into separate columns using Microsoft Excel

In this video tutorial, I will show you how to split data into separate columns using Microsoft Excel. This is a useful process when you want to take data from a single column and split data into two separate columns. A good example would be when you have a first name and last name in the same column but want to separate these within your Microsoft Excel spreadsheet.

How to write a 1000 word article without ever typing a word

26-07-2017

How to write a 1000 word article without ever typing a word

In this video tutorial, I will use Dragon Speaking Naturally to demonstrate how you can write content for your website without ever tying a single word. Wouldn't it be great if you could type up a 1000 word article without ever touching the keyboard? In this video tutorial, I will show you how I create articles using Dragon speaking naturally.

Mozilla Thunderbird Tutorial Update

13-10-2013

Mozilla Thunderbird Tutorial Update

This is a quick update tutorial for Mozilla Thunderbird. This is a follow-up tutorial for Mozilla Thunderbird e-mail client. In this tutorial will look at the following aspects of Mozilla Thunderbird: Quick filters, Tagging e-mails, Quick search function, Replying to e-mails, forwarding e-mails, CC and BCC recipients, Viewing sent e-mails, Searching sent e-mails, Ordering e-mails by date, Ordering e-mails by the recipient

26 key steps to build a powerful personal brand

12-01-2020

26 key steps to build a powerful personal brand

Building a personal brand is no longer the exclusive domain of celebrities and sports stars alone.  An established personal brand for all professionals is vital...

GET YOUR FREE QUOTE


CLAIM YOUR 2 HOURS

FREE CONSULTANCY


  • AFFORDABLE PRICING
  • 15 YEAR KNOWLEDGE
  • LONDON BASED DESIGN AGENCY

NO OBLIGATION QUOTE

arrow
Please enter your name
Please enter correct email
Please enter your phone number
Please enter your message

Your data is encrypted and never shared.
View our privacy policy.

Thank you for contacting us.
We will reply to you in next 2 working days.

back