Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question