Want Whole Row To Shade Gray When Drop Down Item In Row = "completed"
Jul 16, 2009
I have a a worksheet with a drop down menu in one column to show various completion status options (Not started, In progress and Completed). I was able to use conditional formatting to change the color of the cell to gray when I choose "completed" from the drop down menu, but I would like the whole row in view (about 8 cells across) to shade to gray when I choose "completed" from the drop down - not just the completed cell. I'm thinking an IF statement would work, but I don't know how to use an IF statement to shade a range of cells a color.
View 3 Replies
ADVERTISEMENT
Oct 21, 2013
I have a *.bmp image file. It is gray scale only. It amy be up to 1000 x 1000 pixels.
I want to extract the numerical value of each pixel and deposit the values into an Array for further processing.
View 1 Replies
View Related
Jun 9, 2008
I want to get the value for the selected item from the combo box in excel. I don't know very much excel but I want do this forlmular.
See attachment. I want in this box real value…. If I choose livingroom I want to show value of livingroom = 20
View 2 Replies
View Related
Nov 21, 2006
I plan to place a drop down list (combo box) in a WS where I upon selection of one item from that list will move me to the place in the same WS where the item selected is to be found. Hyperlinks are a theory, but the WS is protected and will stay protected. A drop down is preferred.
I haven't worked with this topics for quite some time and might have forgotten some basics.
View 9 Replies
View Related
Nov 7, 2008
http://home.comcast.net/~unkerjay/CSBG_Sheet.xls
in it, there's a Sheet named:
CSBG Report
which has a drop down list for all possible reports
beginning with "Jan".
There's also a "Totals" sheet which has the corresponding
information for each report totaled in separate columns.
Jan, for instance is totaled in column B.
Feb, is totaled in column C.
And so on.
What I'd like to be able to do, is, depending on
the report selected, to have the information in
the corresponding cells in the "CSBG Reports" Sheet
pulled from the appropriate column in the "Totals" Sheet.
So far, I'm not wrapping my mind around a way to
do this.
View 9 Replies
View Related
May 27, 2009
I am trying to accomplish is to display a dropdown or combobox with a list of choices. I want the backcolor to be shaded light green to match instructional text that appears in the cell above. That I have working with the selections appearing. Once a choice is made I want a separate procedure to run that will somehow know which choice was made.
I can't put the code within the module for this particular sheet as it is dynamically recreated each time the data is refreshed and the code will disappear. This may seem to be an odd practice but this is how 25+ workbooks are coded within this system for my employer's customer and it is a required practice.
View 9 Replies
View Related
May 7, 2008
I have a set of data on excel and would like to make searching for it easier.
I have created a drop down list in cell B4 (say, "Banana", "Apples" and "Orange"). Is there a way that if i select "Banana" in cell B4, excel will automatically go to cell A20 ?
View 3 Replies
View Related
Nov 15, 2008
I am kind of new to Excel programming and would like to know if there is a solution to my problem. What I need is to have a dropdown list (I know how to make this) then select an item from the drop down, then based on the name i select, Excel automatically fill up the rest of the cells.
For example, from the drop down list I select the company name then Excel automatically type the address, phone number, Fax number and the contact name of the company for me in corresponding cells. Is there a way to do this?
View 3 Replies
View Related
Oct 24, 2013
if I can gray out the unused columns. I am creating a template that use only column A to J. I don't want user to be able to see or scroll to the unused columns. Is there any command in the setup that can gray out the unused columns? or maybe VBA codes?
View 2 Replies
View Related
Feb 14, 2007
How do I gray out one group of cells or cell if another is occupied?
View 9 Replies
View Related
Dec 29, 2006
I have a spreadsheet where the user wants gray and white lines to occur starting from row 36. Meaning row 36 is grey row 37 white 38 grey etc. to make it look like old accounting paper. The problem is there is a macro that runs to hide the zeros so I cannot preformat the rows because they will change along with the worksheet. Also, the coloring should stop when there is nothing more in the rows, usually around row 100.
View 9 Replies
View Related
Jan 11, 2010
I'm working on a worksheet that another person started. For some reason there are dotted gray lines around every single cell in the print area in the print preview (no idea what this person did or who this person is, so I can't ask them). Anyhow, I need to get rid of these dotted gray lines. Clicking on no borders does not work.
View 9 Replies
View Related
Dec 13, 2013
IF the list value in D2 is = to MT,GP,or H then I need the entire row 2 to turn light gray.
View 6 Replies
View Related
Feb 16, 2013
Excel Userform
VB:
'enables user to click [U]highlight and select[/U] an item in ListBox1 and ListBox2 item (same row in index) is also [U]highlighted[/U] (highlighted only not selected)
Private Sub ListBox1_Click()
ListBox2.ListIndex = ListBox1.ListIndex
End Sub
Question: Is it also possible to enable a user to click to select an item in ListBox1 and ListBox2 item is also selected simultaneously (same row in index). Is there excel vb code to do this?
I think the code may be along the lines of the ListBox SelectedIndex property. What would be the Excel VB code equivilant for the ListBox SelectedIndex property, if so?
View 8 Replies
View Related
Oct 6, 2006
I have a large workbook with hundreds of rows of data.
I have sorted the data and ended up with product codes in column A and my data between columns C and V.
I want to do a sumif with a difference if that is possible.
I want to sum all of the data in column C based on the product code in Column A. But I don't want to include any rows of data where Column V is blank.
i.e. If my sumif for a product code covered 3 rows C3:V5
I want to sumif Column C dependent on the product code in column A but I only want to include rows where there is a value in Column V.
So if all of the cells between C3:V3 contain data include count C3.
Moving down to row 4 if this row only has data between C4:M4 don't include C4.
Moving down to row 5 if this row has data C5:V5 include C5 in the sumif.
i.e if there was 100 in C3, 200 in C4 and 300 in C5 the sumif would be 400 because although C4 has a value V4 does not.
I want to roll this out across all of the columns C:V using the same method if possible.
View 7 Replies
View Related
May 20, 2014
numberdesc
1_______yellow
1_______yellow
1_______blue
2_______purple
2_______purple
3_______green
3_______orange
4_______black
I need some way that can identify when the item in the description column doesnt match the first item of the same number- for example, here the 1-blue and 3-orange would be flagged because they should match the 1-yellow and 3-green.
I need to do this on a much larger scale (approximately 20,000 data points), so I wanted to create a formula or macro that could do this for me.. I thought making a reference page with would work but I keep getting an error.. I haven't done VBA in a while, so I may have syntax errors.
If Range("A2:A9").Sheets("Sheet1") = Range("A2:A6").Sheets("Ref") And Range("B2:B9").Sheets("Sheet1") = Range("B2:B6").Sheets("Ref") Then
Range("C2:C9").Sheets("Sheet1") = "x"
End If
View 2 Replies
View Related
Jun 14, 2014
I am getting close to finishing the drop down menu capability when filling in column L in tab Transactions. However, there is a snag. When I enter part of account say "fin" (the important part here is that the part of the word should not be the beginning of the account name) - then I select an account from the menu - but it does not stay in the cell if the part of the name is the beginning of the account name - all is fine.
View 4 Replies
View Related
Jul 12, 2006
We have a spreadsheet in use at the moment which has various lines of information, each line has a customer name, id, request and various other bits of information which needs looking into.
The infomation is arranged onto weekly sheets and is managed manually. Once the customer request is complete, we grey out the background colour. Some outstanding issues background colours are either left blank, yellow or red, depending on whos doing them.
I was wondering if there is a search criteria that we could use that would search through all the sheets in the workbook and find any customer queries that are not greyed out and display them on the results page.
View 8 Replies
View Related
Jul 9, 2013
I have the following setup on a worksheet :
5427 Data
5427 Data
5427 Data
6565 Data
6565 Data
7765 Data
all I want to do is have the above table look like this :
5427 Data
6565 Data
7765 Data
The concept being that I can double click that row to see the additional information(i.e. expand to show extra information)
Real life use would be of such, the first column contains the invoice number, the 2nd 3rd etc contain item associated with such invoice.In grouping the column invoice number, you only have to look at one invoice, instead of it duplicating for each item contained within the invoice.
This will need to be done in an efficient manner(over 4000 rows need grouped)
I realize I could just create a list that has one copy of the duplicates, but I want to extract the original information as well. For example, it would look like the following :
Original :
1212 Data
1212 Data 2
1212 Data 3
2323 Data 1
2323 Data 2
Edited :
1212
2323
double click 1212 for :
1212
+Data 1
+Data 2
+Data 3
2323
Note : This grouping will also have to span across the whole row, sample rows :
Invoice# Price Color Weight Item
1212 Column1Data Column2Data Column3Data Column4Data etc.
1212 Column1Data Column2Data Column3Data Item2Column4Data etc.
View 4 Replies
View Related
Aug 11, 2012
I am trying to come up with a composite score that if a child takes a particular course and has a grade then make a composite score. Here is an example below.
ABCDEFGHIJK1Math CourseScience CourseReading CourseWriting CourseÂ
MathScienceReadingWriting Composite Score Looking for2APGEAPAP A+BC-B- 11003
In the example below I am looking for a composite score of 1100. Here is how I derived at it!
=4*100 + 3.2 * 50 + 2.4 * 100 + 3.0 * 100 = 1100
Code:
Function composite(r As Range, course As Range) As String
Dim d As Double
Dim score As Double
[Code]....
View 7 Replies
View Related
Jan 23, 2014
What I am trying to do is record the time when a task is completed on the spreadsheet. For explanation sake, lets say I have list of 10 tasks in column C 1-10. In column B 1-10 I have a button for each task. When you press the button for the task, the time it was pressed is recorded in D 1-10. To put the time in I used =now(). The problem that I am having is, when you press button 2-10, it changes the time in the cell above to the same time. So instead of have 10 different times in 1-10, I have 10 identical times,being the last button I pressed. I tried timestamp, time value, etc
View 1 Replies
View Related
Aug 27, 2007
I need to be able to have users complete a range of mandatory cells before they are able to close a workbook.
Foe example cells c5,c10,i11, i18,i22 i24,i26 etc etc need to have data in them before uses is allowed to save or close the workbook. I would like to have a message box prompt to alert them to the issue.
View 9 Replies
View Related
Aug 23, 2006
I have a little problem and could use some help please.I created a worksheet for logging orders but now find it too large to cut and paste but have little knowledge of macros
I would like to have any completed rows moved to another sheet in the same workbook ...
View 9 Replies
View Related
Jun 25, 2008
This seems easy in theory but it's above my head. I have written code to add text and numbers from a userform to certain cells on a worksheet. Now, is it possible to display a message box after the code executes to acknowledge the code has executed successfully? I have tried simply adding the Msgbox function at the end of the code but that does not work.
View 2 Replies
View Related
Mar 3, 2013
I am maintaining a spreadsheet to enter all my sales orders. I need a code which automatically moves the entire row to a new sheet "Completed" when the order status is selected as "Completed".
View 6 Replies
View Related
Jan 27, 2014
I've got a password protected spreadsheet with only certain cells unlocked to allow users to complete them. I need the following to work on Excel versions 2003, 2007 & 2010.
Cell E3 has a drop down list with types of car to choose from. One of the car types is "Pool_Car".
Cell D12 should only be used if "Pool_Car" is selected from the drop down list. If any other car type is selected, and the user tries to enter a figure in D12, I need an error message to appear.
E3 & D12 are unlocked cells.
I'm happy for D12 to become locked & only allow it to be unlocked if "pool_car" is selected, but I've looked elsewhere, but can't find VBA or data validation to work.
View 3 Replies
View Related
Dec 15, 2008
I'm trying to run a macro that only shows completed projects, which means all elements of a project have been labeled "Completed". See example below; 1868 is the only project I want to see when I run the macro, 1869 and 1870 are fully complete, so I don't want to see them.
Project #Status1868Complete1868Complete1868Complete1869In Process1869Complete1870In Process
View 11 Replies
View Related
May 6, 2009
I am trying to figure an easy way to create a formula or possibly even a simple macro to determine % completed of a particular activity (milestone) within a process. Within each activity there are 5-10 items that need to be accomplished. Each Activity could have a different number of items. In order to provide status at an activity level, each item within the activity will be designated with an N/A (0%), Not Started (0%), Just Begun (25%), Half Complete (50%), Wrap up (75%), or Completed (100%) from a drop down box that the user will select. Each one of these criteria can have a weight assigned to it that is in parenthesis. How do I come up with a formula based on the choices above to reach an overall percentage for the activity at any given time and then tell me status level in descriptive terms of the overall activity....
View 9 Replies
View Related
Sep 1, 2009
Any time that any data is entered into one of the cells within my spreadsheet I would like the cell in which data is entered (and only the cell in which data is entered) to automatically become shaded (gray, preferably). I know conditional formatting should be used, but beyond that, I have no clue what to do. I would also prefer not to have to enter in conditional formatting formulas into all 105 cells, but I will do it if necessary.
Just in case, here's a little more information on what I am doing: I will be sending this spreadsheet out to about 10 others, and when they enter their name on a particular day at a particular time, I want that cell to become shaded. Other people might also enter their names at that day and time as well, so I would want the cell to stay shaded if that happens. Macros are not an option, because of security reasons.
View 4 Replies
View Related
Jun 4, 2014
I have a spreadsheet with columns a-v. Column F (titled aging) displays how many days old an issue is. I would like to have a macro that will automatically shade a row light red if the number is less than 90. I don't want the entire row shaded, just the contents of column a-v.
View 2 Replies
View Related