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

Extract Numerical Pixel Gray Values From Gray Scale BMP Image

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

Return Corresponding Data To Drop-Down Item

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

Drop Down That Takes Me Where The Selected Item Is Found

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

Formulas Based On Drop Down List Item

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

Run Macro Procedure Based On Drop-Down Item Selected

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

Go To Cell Based On List Item Chosen From Drop-Down

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

Select An Item From Drop Down List And Automatically Fill A Number Of Cells

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

How To Gray Out Unused Columns

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

If Cell A# Is Occupied Gray Out B#

Feb 14, 2007

How do I gray out one group of cells or cell if another is occupied?

View 9 Replies View Related

Code For Gray And White Rows

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

Dotted Gray Lines Around Cells In Worksheet

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

Cell Formatting - Turn Entire Row To Light Gray

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

Click Item In ListBox1 And ListBox2 Item Is Also Selected Simultaneously?

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

Sum Completed Data Only

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

Flag Item When Doesn't Match Item Above

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

Selecting Item In Combobox - Item Not Get Selected

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

Indentify Completed Rows

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

Need Special Sort Method Completed

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

VBA Function Composite Score Needs To Be Completed?

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

Record Time When Task Was Completed?

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

VB To Have Mandatory Cells Completed Before Exiting

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

Move/Cut Completed Rows To Another Worksheet

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

Message When Code Has Completed Successfully Or Not

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

Move Entire Row To Another Sheet When Cell Value Completed

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

Data Validation Dependent On Another Cell Being Completed?

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

Find Only Fully Completed Projects Using Macro

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

Formula For Possible Weighted Average Or % Completed For A Process

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

Shade Cells With Data

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

Macro That Will Shade Entire Row Red

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







Copyrights 2005-15 www.BigResource.com, All rights reserved