I hope you enjoy reading our blog posts. If you want DCP to build you an awesome website, click here.
Libre Office conditional formatting tutorial
26-09-2017
Back(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
Tell Us Your Thoughts
Thank you for contacting us.
We will reply to you in next 2 working days.
Pankaj has 16 years of website project management experience, working on a diverse range of web and creative design projects for clients based in the UK and overseas.
Releated Posts
14-12-2018
Open Office 4 Writer Tutorial
In this video tutorial, I will show you how to create a business letterhead using Open Office 4 Writer. You will be able to save the letterhead as a PDF file and you can then simply email to your customer so no printing required :)
02-03-2022
Ultimate productivity hacks to grow your designing business in 2022
Growing any business in the era of COVID can be daunting. Not only is the management getting more challenging in these volatile times, but the constantly evolving market situation also makes it difficult for businesses to come up with effective strategies.
02-11-2018
How to create a CSV file using Libre Office Calc
In this video tutorial, I will show you how to create a CSV file using Libre Office Calc CSY stands for "Comma Separated Values". I often use CSV files when uploading data to third-party websites. CSV files can be opened in LibreOffice Calc, Open Office Calc, and Microsoft Excel.
26-09-2017
Libre Office conditional formatting 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.
