| Thread | Last Post | Replies |
|
| How can I make a drop down box visible within a worksheet? | 18 Aug 2008 16:13 GMT | 24 |
I have created several Drop Down boxes in a worksheet but I want to make them visible so people know there is a drop down box there. Right now the arrow doesn't show until you click on that cell. Please help I am not quite sure how to format it so the drop down arrow stays.
|
| count if for more than one criteria | 18 Aug 2008 15:57 GMT | 5 |
For several items listed in rows, I have one column with values "old" and "new" . In each column in the array I have months from 01/2004 through 12/2014. I want to count values in the array that are more than 0.2 and "new" in one row and more than 0.2 and "old" in a second row. ...
|
| Counting number of cells that match name AND number | 18 Aug 2008 12:03 GMT | 4 |
Hi, I need to find a way to count how many times in my worksheet there is a match between a name and a number. example -
|
| HYPERLINK | 18 Aug 2008 09:54 GMT | 11 |
Can I create a HYPERLINK from a drop-down list? Thanks Bobby
|
| ColorIndexOfOneCell | 17 Aug 2008 22:53 GMT | 8 |
Using the following function from... http://www.cpearson.com/excel/colors.aspx I [ALT] F11, right-click on Modules, Insert and pasted.. Function ColorIndexOfOneCell(Cell As Range, OfText As Boolean, _
|