I'm attempting to place a border between two rows in columns A through M
whenever a number in column A changes (using Excel 2007). I've tried =A1<A2
with A1:M16 selected but the border only appears in column A. There is no
border in columns B through M except in row 16. It seems I'm missing
something simple.

Highlight that same range again with A1 as the active cell, and change
your Conditional Formatting formula to:

=$A1<$A2

Hope this helps.

Pete

On Apr 15, 3:32*pm, BillMc wrote:
I'm attempting to place a border between two rows in columns A through M
whenever a number in column A changes (using Excel 2007). *I've tried =A1<A2
with A1:M16 selected but the border only appears in column A. *There is no
border in columns B through M except in row 16. *It seems I'm missing
something simple.

=$A1<$A2

--
HTH,
Bernie
MS Excel MVP


"BillMc" wrote in message
...
I'm attempting to place a border between two rows in columns A through M
whenever a number in column A changes (using Excel 2007). I've tried =A1<A2
with A1:M16 selected but the border only appears in column A. There is no
border in columns B through M except in row 16. It seems I'm missing
something simple.

"Bernie Deitrick" wrote:


=$A1<$A2

--
HTH,
Bernie
MS Excel MVP


"BillMc" wrote in message
...
I'm attempting to place a border between two rows in columns A through M
whenever a number in column A changes (using Excel 2007). I've tried =A1<A2
with A1:M16 selected but the border only appears in column A. There is no
border in columns B through M except in row 16. It seems I'm missing
something simple.


Thanks for the responses. I tried =$A1<$A2 and it only placed the border in column A at every change occurrence and I the border to extend across to column M.

Select all the cells used in columns A through M prior to applying the CF.

HTH,
Bernie
MS Excel MVP


"BillMc" wrote in message
...


"Bernie Deitrick" wrote:


=$A1<$A2

--
HTH,
Bernie
MS Excel MVP


"BillMc" wrote in message
...
I'm attempting to place a border between two rows in columns A through M
whenever a number in column A changes (using Excel 2007). I've tried =A1<A2
with A1:M16 selected but the border only appears in column A. There is no
border in columns B through M except in row 16. It seems I'm missing
something simple.


Thanks for the responses. I tried =$A1<$A2 and it only placed the border in column A at every
change occurrence and I the border to extend across to column M.

"Bernie Deitrick" wrote:

Select all the cells used in columns A through M prior to applying the CF.

HTH,
Bernie
MS Excel MVP


"BillMc" wrote in message
...


"Bernie Deitrick" wrote:


=$A1<$A2

--
HTH,
Bernie
MS Excel MVP


"BillMc" wrote in message
...
I'm attempting to place a border between two rows in columns A through M
whenever a number in column A changes (using Excel 2007). I've tried =A1<A2
with A1:M16 selected but the border only appears in column A. There is no
border in columns B through M except in row 16. It seems I'm missing
something simple.


Thanks for the responses. I tried =$A1<$A2 and it only placed the border in column A at every
change occurrence and I the border to extend across to column M.


My mistake. It did work. I just neglected to delete a previous format. Thank you very much.