Conditional formating (coloring the variables)

Conditional formating (coloring the variables)

Hello,
Our company is thinking of using zoho for data visualization.

We want to create tables with conditionaly formatted cells. Specificely I'd like to add this formula into the cell(pseudocode) :
If (Average value of the column1 > cell.value) then set colour of the cell to "red"
else
set colour of the cell to "green".

Is this kind of visualization possible in zoho?

Thank you for the answer in advance.