Conditional Border

[BillMc]

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.

 

[Pete_UK]

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

=$A1<>$A2

Hope this helps.

Pete

 

[Bernie Deitrick]

=$A1<>$A2

 

[BillMc]

=$A1<>$A2

--
HTH,
Bernie
MS Excel MVP





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]

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

HTH,
Bernie
MS Excel MVP

 

[BillMc]

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

HTH,
Bernie
MS Excel MVP





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