First  |  Prev |  Next  |  Last
Pages: 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127
cell vlue based on cell back colour
Cell Range A1:A35 are different colours (Red, Green, Blue - depending on their value) I want B1:B35 to show a number, based on the colour of adjoining cells. Is there a simple formula that will allow me to do this? TIA >(*-*)< Esra ... 3 Apr 2010 13:44
Alert Message After Somthing Changed
Dear experts, I've a folder contains 30+ workbooks in a network. Each workbook is for one department to fill in different kind of requests. From column A to E, they need to fill in date, time, name, department and request details. I want an alert message can prompt me if an user fill in a new request so that I... 30 Mar 2010 01:49
Folder listing
I want to get a folder listing (from a specific folder) that shows sub folders in the next column (under the parent folder). How do I do that does anyone know? TIA >(*-*)< Esra ... 30 Mar 2010 20:45
Calculating column A * column B = Results in another column
How do i calculate a whole list in one column (B1-b6) (mathematical function i.e. multiply, divide, summation) with another column (c1-c6) and have excel display the output in another set of columns (d1-d6) i.e. input X input = output by excel b1 X c1= d1 b2 X c2= d2 b3 X c3= d3 b4 X c4= d4 without me hav... 30 Mar 2010 00:44
Writing an IF statement in Microsoft Query
I'm querying our Oracle data to Excel and can't seem to get a formula return as a new field. I need the proper way to write this sequence: IF(RM.RM_STD= "LOCKER",50,RM.RM_AREA*RMSTD.COST_OF_SPACE) Which would basically say that if the room standard is a locker, we charge $50 - otherwise, take the room are... 29 Mar 2010 22:32
Conditional Formatting on Range of Cells
My Range is A23:M:23. I want these to be a color if the contents of N23 is F. I have tried, =$N$23="F" as well as =$N$23=F without any luck. Any suggestions? ... 29 Mar 2010 21:26
Share a workbook
I am working in Excel 2007 in workbooks created in 97-2003. When I try to share the workbook, the program goes the motions then gives me a message the workbook is no longer shared, and I can't do anything in the workbook. I close the workbook out and reopen. Then I am back to square one. This is a new problem s... 29 Mar 2010 18:07
how do I create independent results?
Brute force and ignorance but it does it. Extending to more cars/drivers gets very tedious. A little more finesse anyone. Sub assignDriver() Dim driverName(4) As String Dim i As Integer 'Assign driver names to array driverName(1) = "Steve" driverName(2) = "Mary" driver... 29 Mar 2010 15:52
Need some help BAD with conditional formatting
I have 2 sheets with infomation. Sheet1 C2:C15000 have some text in each cell. Some cells in C2:C15000 have the same text, or may have slightly different text. Sheet2 E3 has a free text cell that my end users can type into it at will. I like to turn the Cells C2:C15000 in Sheet1 to turn yellow if the keyword in... 29 Mar 2010 21:26
Doing a countif against a substring of the range to be scanned
I need to see how many cells in a particular range have a substring that matches the text against which I'm searching. So, for example, I've tried the following formula: COUNTIF(left(B2:B292,10),"="&left(cell("contents",P242),10)) I knew that this wouldn't work, but I was hoping that being able to evaluate ... 29 Mar 2010 13:39
First  |  Prev |  Next  |  Last
Pages: 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127