-
bman1965 Simply, you can't bring through formats with a function. It can be done with code but it's complexity will depend on the number of different formats you are wanting to handle. What it appears you want to do though is use Conditional Formatting (C/F) throughout the workbook and whatever...
-
Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
-
@Nick: Paste Special -> Formats works fine if there are no other formats for the cell you wish to preserve, such as number formats, borders, or other aspects of the format you are not adjusting conditionally. @Anonymous: A technique I often use to copy conditional formats (in Excel 2003) is to: Select...
-
It would be very helpful to be able to duplicate conditional formatting rules as a basis for making a new rule, or to get the original rule copied into a new sheet in the workbook. Having to make every rule up from scratch means a lot of clicking around to set formats and such which could be easily copied...
-
Brad Sure there is, check out conditional formatting in help (It's under the Format menu)
-
Michael That's a good plan, I never thought of less, but I suspect we will see some work here in V.Next as it is a little under-cooked. Whilst it is tough to represent, I would also like something to show deciles graphically. We use that all the time here in mail order. It's the opposite end...
-
Interesting, I hadn't noticed that and can't think of a reason why it doesn't work. If you were looking to show something as no longer available, you could use a strikethrough effect