| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting not getting sorted
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First Value in Sorted Column is Not Sorted Properly | Excel Discussion (Misc queries) | |||
| Conditional formatting does not follow value when list is sorted | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Drawing Lines Between Sorted Groups | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
