I want to use conditional formatting with data bars based on the value of a different cell. The cell to show the data bar is a text cell in the same row as the cell with the value. ie; cell D14 contains the item description and cell X14 contains the amount. I want the data bar in the cell with the description based on the value in X. Possible?
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …