How to use Conditional Formatting with Color Scale in LibreOffice Calc 🔥🔥

Hi friends
I am Rahul. Welcome to my channel OFFICE NOTEBOOK.

Is video me humlog discuss karenge Data Validation | Data Validation in Libreoffice Calc ke bareme.To aplogo ko a video bohot pasand ayega. Is video ko jaroor ant tak dekhiye.
📗 Color scale (2 Entries)
This type of formatting analyzes number values in cell range and sets up color for
cell background depending on the value in the cell. User can select any color for minimum
value and maximum value.
By default it selected changing of color from minimum value to maximum value in
cell range. But you can select another option for extreme values from drop-down lists:
Min, Max, Percentile, Value, Percent, Formula.
Min – is in cell range it will automatically defines minimum value that will have the
start color.
Max – in cell range will automatically defines maximum value that will have the finish color.

📗 Color scale (3 Entries).
This type of conditional formatting analyzes numbering values in selected cell range
and set background color for it from two pairs of color: from minimum to intermediate
and from intermediate to maximum. So it uses three user defined colors. By default it
changes color by value in cell from minimum in range to maximum in range. Also it uses
additional mark – intermediate value equal 50 Percentile of range by default.
Intermediate value has its own color. You can select next option for extreme values
from drop-down lists: Min, Max, Percentile, Value, Percent, Formula. Those variants fully
coincides with variants for values in Color scale (2 Entries).

Channel ko jaroor SUBSCRIBE kar le.
Thank you.

#libreoffice
#libreofficecalc
#libreofficetutorial
#libreofficetutorialforbeginner