Conditional formatting referencing the current line

Question

My problem is very simple:

For each row: if column A is not empty, then column C must be color.

So, in the conditional formatting rules manager (after the entire column C was previously selected), I tried formulas with concatenation, indirect, ROW, thiscellerow, and I don't know that again, without any problems, with an equal condition ( just for try it out) i give up ...

At the moment, my formula is:

=INDIRECT("$A"&ROW())<>"" 

Excel automatically changes to this:

="INDIRECT(""A""&ROW())<>""""" (to escape all the ")

Can anyone help me with this please?

Answer 1

You do it too hard.

Rule: =$A1<>""
Applies to: =$C$1:$C$10 (you define your own end)