Excel - Conditional Formatting Problems for Excel 2003
Asked By Wayn
11-Apr-07 08:54 PM
I can no longer apply conditional formatting to cells in Excel 2003. I have
half of the sheet formatted and have gone to format the rest of the cells but
have found that the conditional formatting option is now "greyed out". I
have tried to copy and paste the formats also to no avail....
Mik replied...
Is your sheet protected if so unprotect and that should do it
mailTo hyperlinks in Excel? Excel Excel creates bogus "mailTo" hyperlinks on entering some simple cell formulas like @sum. I know how to remove individual hyperlinks. Is there a way to prevent this silly behavior. Thanks. Excel Miscellaneous Discussions Excel (1) Don't use @sum() Try using = sum() - - Dave Peterson keywords: mailTo, hyperlinks, in Excel? description: Excel creates bogus mailTo hyperlinks on entering some simple cell formulas like @sum. I know how
VBA2D Array Excel Excel , Excel" / > Quick syntax question: is there a way to copy one colunn of a 2D array into excel directly and vice versa? I.e. I have a 200*10VBA array, and I want to plug the value of the 7th column into one Excel Column. Of course I don't want to enter values in Excel one by one. For the moment I fill an intermediary VBA Array of 200*1 expect to be able to do things a bit more directly. Any idea? Thanks Charles Excel Discussions Array (1) Excel (1) Syntax (1) Question (1) Colunn (1) Directly (1) Versa (1) Value (1) Charles wrote
how do i insert a chart from excel? Excel Excel Charting Discussions PowerPoint (1) Excel (1) Workbooks (1) Windows (1) @ says. . . Copy. Paste. - - Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions How do I insert a chart in Excel? or How do I insert an Excel chart into another program? To copy a chart between two excel work book 1. On the Windows menu, click Compare side by side All Workbooks are
Have you tried my suggestion from your post in "microsoft.public.excel.excel"? Excel Have you tried my suggestion from your post in table to get the correct aggregation of XL you are on as pivot tables changed substantially in XL2002. . . - - HTH. . . Jim Thomlinson Excel Programming Discussions XL (1) WOS (1) HTH (1) Excel (1) Microsoft (1) Instructions (1) Aggregation (1) Calculation (1) keywords: Have, you, tried, my, suggestion from, your, post, in, "microsoft.public.excel.excel"? description: Have you tried my suggestion from your post in microsoft.public.excel.excel You need to calculate the WOS in the pivot table to get the correct
How do I sort alphabetically in Excel Excel Excel Miscellaneous Discussions Alphabetically (1) Excel (1) Hello, seh60025! You wrote on Thu, 26 Oct 2006 14:18:01 -0700: Use obvious alterations: not.jim.silverton.at.comcast.not keywords: How, do, I, sort, alphabetically, in, Excel