Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XL 2007: Conditional Formatting not saved
I have been posting this question for some weeks now, with no responses. Am
I posting it in the wrong place? (Excel 2007) I have conditional formatting that is based on an array, applied to all cells in a worksheet. The formatting underlines every third row after the monthly totals by: =MOD(ROW()-MAX(ROW($A$1:$A1)*($A$1:$A1="Totals for")*($A1<"Totals for")),3)=0 The words "Totals for" appear in col A, various rows. For test purposes I have them in A41 and A78, and the word "Date" in A4, and the formatting shows correctly. When I save and close the workbook and re-open it, the wrong rows are underlined. If I go to the "Edit rule" screen and click OK without changing the rule, then Apply, the rule works correctly until next time I save, close and re-open the workbook, when rows 42 and 78 are underlined. Editing the rule (without changing it) and applying once again gets the correct rows, 44 and 81, underlined, but the result is always lost on saving. Using arrays like this worked fine in earlier versions of XL. It fails in XL 2007 in both compatability mode for old XP workbooks and for new workbooks. It makes no difference whether I am using Win XP or Vista, and fails on every computer that I have access to. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Icon Set Information Lost when saved as H | Excel Discussion (Misc queries) | |||
2007 Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting in 2007 | Excel Discussion (Misc queries) | |||
XL 2007: Conditional Formatting not saved properly | Excel Programming | |||
XL 2007: Conditional formatting not saved properly | Excel Discussion (Misc queries) |