Ikkitote Gede suudisamme loosansanni

Using the menu command Format - Conditional - Condition, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format.

Ikkitote gede suudisamme ledo, lawishshaho, baalante ledo mereerima hornyo roortanno ledo kuulsiisa dandaatto. Ledo soorranturo, wole akatta angatenni loosansinikkinni suudisammeno soorrantanno.

Ikkito tirate

1. Ikkitote gedi akata losaansate hasiratto bisiccuwa doori.

2. Choose Format - Conditional - Condition.

3. Hasaawu saaxine giddo ikkito(s) eessi. Hasaawu LibreOffice Help giddo tittirame xawisamino, hattono lawishshu woroonni shiqeno:

Ikkitote gede Suudisamme: Ledo Mereerima Hornyo Aleenni/Woroonni kuuliissanni

Qaafi1: Kiirote Hornyuwa Kalaqi

Sha'ate hexamanyora hornyuwa aa hasirittoro. Lawishshaho, shaete giddo mereerimu aleenni noo hornyuwa haanjatenni hattono mereerimu woroonni noo hornyuwa buumetenni leellisha dandaatto. Kunini ikkitote gede suudisammenni dandaamanno.

1. First of all, create a table in which a few different values occur. For your test you can create tables with any random numbers:

   Mitte bisicco giddo =RAND() afi'rimala eessi, hakkiinnino randeme kiiro 0 nna 1 mereero afiratto. 0 nna 50 mereero noo intijere hasirittoro, =INT(RAND()*50) afi'rimala eessi.

2. Randemete kiiro haawiittimma kalaqate afi'rimala hinkiili. Doorantino bisicco woriidi qiniiti cawe qiphisi, hasiroottoti bisiccote hakkigeeshsho doorantanno geeshsha qiniite wido goshooshi.

3. Aleenni xawinsoonni garinni, randeme kiiro lexxo haawiittimma kalaqate qiniiti qacce bisiccote cawe wororricho goshooshi.

Qaafo 2: Bisiccote akatta tiri

The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles window is visible before proceeding.

1. Fano bisicco giddo qiphise Suudishshu Bisiccuwahajajo eigaru mayino giddo doori.

2. In the Format Cells dialog on the Background tab, click the Color button and then select a background color. Click OK.

3. In the Styles deck of the Sidebar, click the New Style from Selection icon. Enter the name of the new style. For this example, name the style "Above".

4. Layinkki akata tirate, fano bisicco giddo marro qiphisse aleenni xawinsoonni gede loosansi. Bisiccote Babbaxxitino badhillichu kuulishsha gaamitto gedensaanni su'ma gaami(kunni lawishshira,"Woroonni").

Qaafo 3: Mereerima Shallaggi

Lawishshinke giddo, randemete hornyuwa mereerima shallanganni heen'oommo. Gumu bisiccote giddo ofollanno:

1. Wirsa fano bisicco giddo wori, lawishshaho, J14, hakkunni gedensaanni Surka - Assishsha doori.

2. Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the Shrink icon.

3. Assishshu kaa'laancho Ee nni cufi.

Qaafo 4: Bisiccote akatta loosaansi

Xa shittete ikkitote gede suudisamme loosaansa dandaatto:

1. Baalantta bisiccuwa sa'e sa'e doori.

2. Choose the Format - Conditional - Condition command to open the corresponding dialog.

3. Ikkito kunni woroonni noo garinni tittiri: bisiccote hornyo J14 nni ajjuro,"Woroonni" bisiccote akatinni suudisi, hattono bisiccu hornyo J14 nni taalturo woy roorturo, "Aleenni" bisiccote akatinni suudisi.

Qaafo 5: Bisiccote akata hinkiili

Wole bisiccuwara gedensaanni ikkitote gede suudisamme loosansate:

1. Mitto ikkitote gede suudisamara gaamamino bisicco qiphisi.

2. Bisicco klipbordete wido hinkiili.

3. Tenne addarricho suudisamme adhitanno bisiccuwa doori.

4. Choose Edit - Paste Special - Paste Special. The Paste Special dialog appears.

5. In the Paste area, check only the Formats box. All other boxes must be unchecked. Click OK. Or you can click the Formats only button instead.