Hi Lon,
Conditional Formatting is like regular cell formatting in being attached to cells.
Sorting, Some notes on sorting in Excel
http://www.mvps.org/dmcritchie/excel...ng.htm#borders
Shows an example of the shading traveling with the cell but not the borders.
The borders can't travel because borders are shared between cells.
So what is involved with your Conditional Formatting. Mostly what I have
for Conditional Formatting is applied to entire columns. So migration or lack
of it is not a problem for me, plus I don't often sort such lists. What do your
formulas look like for the C.F. and how were they applied.
entire column(s)
copying formatting of a range of cells
individual cells formatted
what is involved
fonts: color, size, weight (bold), italic
borders
shading and patterns
nothing yet related to your problem on my Conditional Formatting page
that I am aware of unless
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Lon Sarnoff" wrote in message ...
My spreadsheet contains a variety of conditional formats. It appears that
those formats are not "travelling" with their cell values when the a range is
sorted by the code shown below, and so the newly positioned data values have
incorrect conditions applied to determine their new formats. What am I
missing? (I am using Excel 2003.)
Selection.Sort Key1:=Range("W5"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
--
Lon Sarnoff