-
Hi Steve, Rather than use VBA, I've developed a worksheet only solution, using dynamic named ranges, LINEST linear regression function, datatables, index/match to pick out the best results, and finally solving the simultaneous equations and plotting!! Sorry I don't have time to explain the whole...
-
Hi all, Anyone who's used to the conditional formattings of Excel 2007? I need to format some cells in a given row, for instance make the beckground red, if the numbers of the cells are smaller than a number in another given cell in the same row. This should be done with 500 columns, and also repeated...
-
OS: Windows XP; MS Excel 2007 I need to update the "price" for a corresponding "Code". The updated Price is in a spreadsheet among as many as 15,000 "Codes" in a column and the corresponding "Price" is in another column in the same row. I need about 400 items updated...
-
As an alternative I would suggest using a set of radio buttons (rather than checkboxes) from the forms toolbox. Then you could simply use conditional formatting to grey out your other rows, based upon the value of the cell linked to the radio buttons. I will see how I go at attacking a sample spreadsheet...
-
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...