Each row: Apply a border to columns A-D when A is not empty (conditional formatting)

[tbschen]

Hello there,

I'm trying to format my Excel file for better overview.


I'd like to have conditional formatting that works like this:
Each row (starting at 2) it checks if column A of that row is not empty.
If it is not empty, format column A-D of that row with a border

Is this possible with 1 condition? Or would I need 2? (1 for A, 1 for B-D)


Thank you for your help!

 

[mumps]

You can use this formula: =A2<>"" but I believe you would have to repeat it for each column A:D.

 

[tbschen]

I think I've figured it out

Range:
=$A$2:$A$1048576;$B$2:$B$1048576;$C$2:$C$1048576;$D$2:$D$1048576

Formula:
=INDIRECT("A"&ROW())<>""

Formatting:
Add row or other stuff