Answer the question
In order to leave comments, you need to log in
How to check if one of the fields in a formula is empty and color the cell if it is empty?
I have, say, 4 cells. In 4, the result of the calculation of the three previous cells is displayed. How can I color this 4th cell red if, for example, 2nd cell is empty? Only 2 cells can be empty. It is necessary to paint 4 - with the result.
Answer the question
In order to leave comments, you need to log in
Easily!
Home / Conditional Formatting / Create a rule.. / Use a formula to determine which cells to format
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question