In Google tables to implement the change color of the cell if the condition "=IF"?

I want to do this: if more L4 B4 to the cell painted green. If not, in red.

While they did so, but instead, the color is "Yes":
=IF(L4>B4,"YES")

Conditional formatting not to offer. Because it works with only one string. And every day I create a new row and create for each row, the conditional formatting is not very desirable. So it's easier to create a condition. The formula picked up, but don't know which option repaints the background of the cell. I need your help.
March 20th 20 at 11:29
1 answer
March 20th 20 at 11:31
There is no such parameter in the formulas, which changes the color. Formula to calculate the value, they don't control the formatting. You just need conditional formatting. Just have a misconception about it.

Because it works with only one string

That statement is incorrect. Set the conditional formatting as in the screenshot, all cells in column K, starting with the third will be green if the corresponding cell of column L more corresponding cell of column B. For red similar.
5ccadb4d5c264488414794.png

Find more questions by tags Google Sheets