L
L
Lynatik0012021-03-02 21:04:26
Google Sheets
Lynatik001, 2021-03-02 21:04:26

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

2 answer(s)
A
Alexander, 2021-03-02
@Lynatik001

603e89645b0ac363333858.png

V
Vladimir Yurchenkov, 2021-03-02
@EPIDEMIASH

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 question

Ask a Question

731 491 924 answers to any question