Conditional Formatting refering to the current row

7
votes

My problem is really simple:

For each row : if column A is not empty then column C should have a color.

So in the conditional formatting rules manager (after have previously selected all column C) I tried formulas with concatenate, indirect, ROW, thiscellerow, with I don't know what again, without anything, with an equal condition (just to test it), I'm giving up ...

For the moment my formula is:

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

Excel automatically changes into this: 

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

Anyone could help me on this please ?

1
excelconditional-formatting

1 Answers

9
votes

You are making it way too difficult.

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

enter image description here