M
M
MakovkinDmitriy2017-09-28 15:04:09
Google
MakovkinDmitriy, 2017-09-28 15:04:09

How to write a conditional formatting formula in Google Docs?

Good day!
There is a Google spreadsheet with data.
On the first sheet, in column G, the percentage deviation of the actual weight from the system weight. On the second sheet, allowable deviations depending on the mass of the goods.
Actually the question is: how to write a formula that will calculate the percentage deviation and "fill" the cell with the required color (from green to red), depending on the actual mass of the goods and the deviation from this actual mass?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question