Libreoffice - Calc - Highlight cell on condition

In Libreoffice spreadsheet, you can highlight cell based on specific conditions. For example, you can define condition such that if the value of a cell is bigger than 0, then turn the cell to green. If the value of a cell is less than 0, then turn the cell to red.

Here is a video showing how to do this.