How to make a border line on a row based on a value



I want to make a border line on a row start from column A - F based on the value in cell A1,

let's say if the value in A1 is 2 make the border line by the second row, if A1 is 3 make the border line by the 3rd row, 

so what I try to do I put a OFFSET function in the Conditional Formatting like this

=OFFSET(A1,A1,0,1,6) but it doesn't work, is there any way to make it?



Selected Answer

You have to format the cell where you wish to have the border, not A1. This is the formula you should apply.


If you wish to quote the row number of a given range modify the above to  reflect the row number of the range. For example,

=$A$1 = Row() - 4

If you apply this formula to cell D5, for example, it would respond to the number 1 in A1 becasue ROW(D5) - 4 = (5 - 4) = 1



Thanks, is works very good, but I need the row number from my range, not from the sheet, lats say I have a range D5:I19, and I want when the user enter the number 3 in cell I21 should the border line be on the 3rd row from this range, and the same think for a lot of ranges
JAExcel (rep: 10) Aug 18, '17 at 11:32 am
Haha. If it works the question was answered. If you have another question accept the answer and ask away.
Variatus (rep: 3838) Aug 18, '17 at 11:44 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login