W
W
weranda2021-07-16 09:21:38
excel
weranda, 2021-07-16 09:21:38

How to color a string if there is a value in it?

Greetings.

If there is a value in a cell of column A, then it is necessary to color the empty fields of the line with an entry in column A. Tell me the exact implementation. I'm trying to apply conditional formatting to the range using the formula =$A1<>"", but I can't complete the formula.

An example of how to:
000.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
Grigory Boev, 2021-07-16
@weranda

Try like this:
=И($A1<>"";A1="")

B
BasiC2k, 2021-07-16
@BasiC2k

There are a bunch of examples . It's worth just looking .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question