View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Conditional Border

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.