Sunday, March 31, 2013

Conditional formatting in LibreOffice 4 on Debian Linux

A video has been made to demonstrate how to apply conditional formatting:
http://youtu.be/zXQnBGMIZnY



Captions:

0:00:00.490,0:00:08.430
>> LibreOffice How-To:
Conditional formatting in LibreOffice 4

0:00:08.490,0:00:15.430
>> Here are some screenshots



0:00:15.490,0:00:18.430
>> Select the cells first
Click on Format -> Conditional Formatting

0:00:18.490,0:00:20.430
>> Click on Format -> Conditional Formatting
-> Condition...

0:00:20.490,0:00:23.430
>> In the Conditional Formatting dialog,
type the number you need

0:00:23.490,0:00:26.430
>> You can use a new style every time

0:00:26.490,0:00:33.430
>> Use quotation marks for the text

0:00:33.490,0:00:49.430
>> Mark the numbers
below forty-nine point five red

0:00:49.490,0:00:53.430
>> Select Format  -> Conditional Formatting
-> Condition...

0:00:53.490,0:01:09.430
>> Follow the instructions on the screen

0:01:09.490,0:01:26.430
>> Highlight the cells containing
numbers below forty-nine point five

0:01:26.490,0:01:30.430
>> Select the cells -> Format 
-> Conditional Formatting -> Condition...

0:01:30.490,0:01:35.430
>> Choose less than
Type forty-nine point five

0:01:35.490,0:01:43.430
>> Select New Style...
-> Background -> the color -> OK

0:01:43.490,0:01:51.430
>> That's it

0:01:51.490,0:01:57.430
>> Mark numbers below
forty-nine point five with brackets

0:01:57.490,0:02:14.430
>> Nearly do the same things

0:02:14.490,0:02:24.430
>> The word General is enclosed in brackets

0:02:24.490,0:02:28.430
>> That's okay

0:02:28.490,0:02:52.430
>> Underline the numbers
below forty-nine point five

0:02:52.490,0:03:04.430
>> Choose Single under Underlining

0:03:04.490,0:03:07.430
>> That is done

0:03:07.490,0:03:16.430
>> Hightlight the cells
containing the values above average

0:03:16.490,0:03:20.430
>> The average is
sixty-nine point one five

0:03:20.490,0:03:29.430
>> Select the cells -> Format 
-> Conditional Formatting -> Condition...

0:03:29.490,0:03:43.430
>> Choose above average
Select a new style

0:03:43.490,0:03:53.430
>> It is complete

0:03:53.490,0:04:08.430
>> Mark the text
containing "A" with brackets

0:04:10.490,0:04:17.430
>> Do something similar

0:04:17.490,0:04:20.430
>> Choose Contains

0:04:20.490,0:04:29.430
>> Type double quotation marks
Choose a new style

0:04:29.490,0:04:35.430
>> Choose Text
The at sign is enclosed in brackets

0:04:35.490,0:04:43.430
>> The words Amy and Angela
are enclosed in brackets


0:04:43.490,0:04:47.430
>> It is done

0:04:47.490,0:05:00.430
>> Highlight the cells
containing nothing

0:05:00.490,0:05:10.430
>> Choose equal to
Type double quotation marks

0:05:10.490,0:05:20.430
>> Choose a new style
Select the background color

0:05:20.490,0:05:25.430
>> It is okay

0:05:25.490,0:05:39.430
>> I may want to do things
in a different way

0:05:39.490,0:05:56.430
>> Click on Format Paintbrush

0:05:56.490,0:06:05.430
>> Select one cell this time
Click on Format -> Conditional Formatting

0:06:05.490,0:06:10.430
>> Click on Format -> Conditional Formatting
-> Condition...

0:06:10.490,0:06:23.430
>> Repeat the steps

0:06:23.490,0:06:32.430
>> Click on Format Paintbrush
Select the cells to apply the new format conditionally

0:06:32.490,0:06:43.430
>> It is complete
There is another way

0:06:43.490,0:06:55.430
>> Copy and Paste Special
Check Formats only

0:06:55.490,0:07:12.430
>> Do similar things

0:07:12.490,0:07:22.430
>> I select a new style
Choose new borders

0:07:22.490,0:07:27.430
>> Select a new background color

0:07:27.490,0:07:42.430
>> Edit -> Copy
-> Select the cells -> Edit -> Paste Special

0:07:42.490,0:07:52.430
>> Uncheck Paste all -> Uncheck some boxes
Keep Formats only

0:07:52.490,0:08:00.430
>> The cells are updated
That's it

0:08:00.490,0:08:05.430
>> You can download LibreOffice 4
at www dot libreoffice dot org

0:08:05.490,0:08:13.430
>> at www dot libreoffice dot org
forward slash download

No comments:

RSS