Pankaj Shah

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.


Releated Posts


Tiny URL Tutorial - URL Shortener Tutorial

28-08-2018

Tiny URL - URL Shortener Tutorial

In this video tutorial, I will show you how to create Shortened URLs using tinyurl.com. If you want to share URLs using popular social media websites or even WhatsApp then shortened URLs are ideal. 

Libre Office 6 - Calc - Basic Formulas Tutorial

09-10-2018

Libre Office 6 - Calc - Basic Formulas Tutorial

In this video tutorial, I will show you how to use basic formulas in Libre Office Calc 6. Understanding how formulas work in spreadsheets can save you lots of time. You can use formulas to repeat processings like adding numbers together or create more custom complex formulas for data analysis.

Useful tips on how to get 1000 shares on blog posts

05-02-2020

Useful tips on how to get 1000 shares on blog posts

Writing awesome blog posts is one thing, but getting people to share your content is another. Your first goal should be to share your newly published blog post across your social media accounts. Use the power of your followers to generate traffic to your blog posts.

How to install free Fonts on Windows 10

26-10-2018

How to install free Fonts on Windows 10

In this video tutorial, I will show you how to install free Fonts on Windows 10. Finding free fonts you can use on your artwork projects is super simple.there are lots of websites where you can download free fonts. In this tutorial, we will download fonts from Font Squirrel.

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