Conditional Border
"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.
|