Menu
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 ?
470
Format Entire Row with Conditional Formatting In Microsoft Excel, with a few easy steps, you can apply conditional formatting that checks the value in one cell, and applies formatting to other cells, based on that value. For example, if the values in column B greater than 75, make all data cells in the same row blue.
On the Home tab, click Conditional Formatting, point to Highlight Cells Rules, and then click Text that Contains. In the box next to containing, type the text that you want to highlight, and then click OK.
You are making it way too difficult.
Rule: =$A1<>""
Applies to: =$C$1:$C$10 (you define your own end)
50
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
