Functions

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