I want to use conditional format to add borders to cells dynamically, like this:
- If cells A or B arent empty, then add a grey border to the bottom of cells A:E
- If cells in the next row of A or B are empty, then add a black border to the bottom of cells A:E
The formula that goes in conditional formatting would be something like this, in pseudo code: OR(Ax!=0;Bx!=0), being Ax and Bx the cells in the row x, which I dont know how to reference.
In the second case I should do the same but adding +1, like AND( OR(Ax!=0;Bx!=0); A(x+1)=0; B(x+1)=0 )
Is it possible to do what I want? Maybe there is a different easier way? I just want to add lines to help reading between the rows, and add a thick line that indicates when its the last cell in the list.
Thanks you
Bookmarks