Change Color Of Group Of Cells Based On Data In Another Group Of Cells

Jan 12, 2014

Conditional formatting. I want to change the color of a group of cells based on data in another group of cells. Example:

If cells G8 and G9 (which are merged) are between 80% and 94%, then I9,I10,I11 (which are merged) will turn Yellow. Also, under the same scenario, IF G8 and G9 is greater than 94%, then cells I9, I10, I11 will turn Red.

View 2 Replies


VBA To Search Group Of Cells And Input Message If Value Is Missing From Group?

Mar 17, 2014

I am trying to write VBA code that groups cells between blank rows and inserts a message if a string of text (a name) is missing from the entire group. I want the code to search cells in column A and group the cells between blank cells. Use the name I input in an input box as the search criteria and insert a message in the Column C next to the last blank cell in the group and then move on to the next group and highlight the cell in red with bold text. I am including a spreadsheet with an example of what the sheet should look like before and after the code is run.

View 11 Replies View Related

Insert Group Header Based On Consistent Value Within The Group?

Feb 10, 2014

I have several groups of data in the same sheet. Each group has two blank rows above the first row of data. Each group has column "B" in common (e.g., "Phone" in the example attached). I'd like to add a title/label of "Phone" to the first column in the row immediately preceding the first row of data for that group.

View 1 Replies View Related

Adding A Group Of Cells Based On Yes In Another Cell

Apr 2, 2014

I am looking for a formula in D7

In col E I have a range of numbers
In Col AA I have yes or no

I would like to add all of the col E amounts from line 18-72 where the answer in AA of the same line is no or blank

18 2.00 Yes
19 3.00 Yes
20 5.00 No
21 7.00

D7 = 12.00

View 2 Replies View Related

Hide Group Of Cells Based On Value Of Cell In Another Sheet?

Nov 14, 2013

Is there a way to hide a group of cells based on the value of a cell in another sheet?

I have attached my spreadsheet.

So, based on the selection in H5 on the 'Wood Selection' sheet, I would like to hide cells on the 'Moisture Controlled Schedule' sheet, and the 'Time Controlled Schedule' sheet.

If Ponderosa Pine is selected, I want it to hide all the douglas-fir info, and vice versa

View 2 Replies View Related

Conditional Formatting - Shade Group Of Cells In Row Based On Value In 1 Cell?

Jul 28, 2013

I have a spreadsheet where I want to be able to Fill cells green in Column B to Column N for any Rows that have a value in Column L. All other Rows should remain the current colour (orange).

I can Fill the cells in Column L using conditional formatting but am not sure if I can use Conditional Formatting on other Columns so that their Fill colour is determined by the value in Column L?

View 3 Replies View Related

Pivot Table Group :: Fill Missing Cells With A Data On Workbook Open

Sep 18, 2008

new data goes into the report, the pivot table looks at a dynamic range and confirmed that the range doesn't select any empty cells.

Just wrote a macro to fill missing cells with a data on workbook open.

all the data is date form, yet still when i refresh the pivot table i look my montly grouping, when i try to group again it says "unable to group"

View 9 Replies View Related

Calculate The Average Of A Group Cells In One Column Based On The Condition Of Another Column

Oct 2, 2008

I'm trying to figure out if there is a formula I could use that will calculate the average of a group cells in one column based on the condition of another column. It's hard to explain, so I will show an example. All the data is on a one worksheet and I'm trying to show totals and averages on another worksheet. Location, Days

17, 4
17, 3
17, 5
26, 4
26, 8
26, 10
26, 7

On a different worksheet I would want to know what the average days are for each location. So is there a formula that I could use that will look at column A for a specified location number and then average all the days in column B for that location? I'm using Excel 2003 and have tried using the Average(if) but with no success.

View 2 Replies View Related

Formatting Group Of Cells To Have Different Decimal Rules Based On Decimal Value

Aug 3, 2006

Basically, I want to format a group of cells to display 1 decimal figure if the number is not a whole number. If the number is a whole number (or if the rounded first decimal place is 0) I want it to display no decimal.

View 9 Replies View Related

Add One Group Of Cells

Apr 12, 2008

im tyring to make excel add one group of cells. but not like 5+5=10 but 5+5=2. confused yet i am. basicly i want it to only count the number of cells with numbers in it. im shipping boxes with differnt amounts in them. but i want to know how many boxs are shipping.

View 13 Replies View Related

Pivot Table Group :: Group By Integers And Not By Months, Years Etc?

Nov 12, 2009

I have date fields as column labels in a pivot table. When I try to group them I'm only given the option to group by integers and not by months, years etc.

I've had a look at the format settings of the column and they are formatted as date fields.

View 9 Replies View Related

Format Group Of Cells

Feb 13, 2014

I have a spreadsheet that contains data with the following format:

12 EA/PK

Unfortunately, sometimes the data is input without a space:


I am looking for a way to insert a space between the data when one does not exist. (I cannot have more than 1 space between the alpha numerical character and the numerical character.)

View 9 Replies View Related

Deleting The Name For A Group Of Cells

Feb 3, 2009

When you highlight a group of cells and give them a reference name- that name seems to be permanent. How do you delete one or add cells to the reference? Example attached book1.xls Cells A1-B3 are named "TheGroup".

View 2 Replies View Related

Increase Value In Group Of Cells

Mar 8, 2009

Can someone tell me it is posible to increase cels value (diferent values) from D2 to D21 for example, by 20. I just start to use excel.

View 6 Replies View Related

Add Characters To A Group Of Cells?

Sep 8, 2009

I have a column of about 3000 numbers that need to be converted to bar codes. In order for the codes to work, I need to place a set of parentheses "()" around each number in the column. Do I need to do this by hand, or is there a function/script for this? Using Excel 2003

View 2 Replies View Related

VBA Merge Cells That Contain Same Value But Within Particular Group

Mar 21, 2013

I have a question regarding automatic merging in VBA. Its similar to this thread (Macro Required - Automatically Merge vertically identical cells) but with a slight twist.

So say if I have four columns set up as follows, where the first line contains headings (before)

Term (years)


[Code] .......

Im looking for something like this (please ignore the periods as i had to put them to keep the table from incorrectly displaying). I'd like to highlight the non-merging of Striker (line 7 and 8 in column2) becasue one belongs to Manchester and the other to Arsenal

Term (years)


[Code] .......

View 3 Replies View Related

Looking For A Cell In A Group Of Cells

Jan 27, 2007

currently i have a address of a cell, i.e. "$C$3". and i want to search for this cell from a few group cells i.e. "Range1 = $A$1:$A$10", "Range2 = $B$1:$B$8", "Range3 = $C$2:$D$8". after searching for the matching cell, the macro would return the name of the group cell to me, i.e. in this case is "Range3". how would i go about doing that? could anyone enlighten me on this?

View 5 Replies View Related

How To Assign Characters For Group Of Cells

May 30, 2014

If I have 5 names like apple, boy, cat, dog, energy

and if i enter a in a cell it should output apple in the same cell.

example: (=IF(A1="a",A1=apple,0))

How to do this?

View 6 Replies View Related

Concatenate Group Of Cells If They Contain Certain Text

Jul 28, 2014

I am trying to figure out how to Concatenate a group of cells if they contain a certain text. Basically I have a list of Architects in column A and the account name in column B... and I want to say Concatenate column A, IF column B=Specific Account (ex: Coca-Cola). The list will be added to frequently so the formula must refer to the entire columns, not just a certain range.

As of right now, only the first architect associated with each account will appear. I have attached a workbook with the example..


View 6 Replies View Related

Assign Same Value To Selected Cells Within The Same Group?

Jul 29, 2014

I have a table with 2 columns A & B and desired outcome in column C (see attached sample).

I need to assign the same value to cells (in column A) located within the same group (in column A) using the following rules:

If any cell value within the same group = W220 or W210 or E240 or E250, then assign value "Group A"

If any cell value within the same group = P210 or C100, then assign value "Group B"

If any cell value within the same group = N230 or N250, then assign value "Group C"

View 3 Replies View Related

Automatically Select Next Group Of Cells

Nov 21, 2007

I have a workbook that contains part numbers and their components listed like below. There is always one empty row between the part number and the components, and then 3 empty rows between the last component and the next part number.

The number of components varies from sometimes only 1 up to 25. Currently, I select a part number and its components like B1:C5 and then I have a macro that copies it to another workbook. What I would like to do is somehow get the macro to automatically select the next set down, in this case, B9:C14, so I could copy every set over to its proper place with only one click of the button.

View 10 Replies View Related

Find Group Of Matching Cells VBA Or Otherwise?

Sep 9, 2013

i have a worksheet that is about 100rows x 100columns.

i would like to create some code to find a certain record. for example..

a1 a2 a3 a4
the record might be " tony tony alex tony"

basically, this group of cells could be any where in the group and i need some code to search the worksheet and then outline it. i just want to be able to find a certain block of cells and outline it.

View 2 Replies View Related

Refers To A Group Of Cells In Another Workbook

Mar 11, 2007

I have some code which refers to a group of cells in another workbook as follows:

Workbooks("SUMMARY06.XLS").Worksheets("JS").Range("H23:H30").Value = ActiveCell.Range("B1:B8").Value

I wish to change the reference to the sheet reference rather than the tab name, but the following doesn't work.

Workbooks("SUMMARY06.XLS").sheet103.Range("H23:H30").Value = ActiveCell.Range("B1:B8").Value

And if I make two or more references to the same Workbook, can I use a with statement, like:

With Workbooks("SUMMARY06.XLS")
.Worksheets("JS").Range("H23:H30").Value = ActiveCell.Range("B1:B8").Value
End With

View 9 Replies View Related

Move Group Of Cells Over 4 Columns

Jan 21, 2009

I need to move a portion of info over 4 columns. I need to do this after a certain criteria is met.

1 Mem# Mem Name Sta Area
2 123C Joe Smith G bev
3 4 Wine 4.95 6
4 5 wine 5.95 6
5 2 food 6.95 5
6 124G Fred Choi C Bev
7 4 Wine 4.95 6
8 5 wine 5.95 6
9 2 food 6.95 5

A3, B3,c3,d3 need to shift over 4 clmns then when nxt member #(a6) is met rows below need to shift over 4 clmns until nxt mem #, so on and so forth. Please Help. New to the macro scene.

View 10 Replies View Related

Hide And Unhide A Group Of Cells

May 13, 2004

Is there a way to hide certain cells using the protect sheet option? Checking the hidden box on the format cells dialogue doesn't seem to do it. I know you can do it by entering ;;; in the custom formating but then if you have to remember which ones you did that too. I would like to be able to hide and unhide a group of cells easily.

View 9 Replies View Related

Count Data Based On Group

Nov 17, 2009

I have excel file in the below format.

Sheet1 ABC1NamegroupGroup22AA13AA4AB25BB6CC27AC48D9ED1 Excel tables to the web >> Excel Jeanie HTML 4

I want count data Based on Group.

The answer is below.

Sheet1 ABCDEF11NameaBCDBlanks12A21113B114C115D116E1 Excel tables to the web >> Excel Jeanie HTML 4

View 9 Replies View Related

Use The Group Box To Group A Number Of Option Buttons Together?

Jan 17, 2013

how to use the group box to group a number of option buttons together.

Question is, lets say, i have a total of 4 group box. if i want it to work in such a way where by once 2 option buttons are being selected (1 option selected from each group box), the rest of the option buttons in the 4 group box will be greyed out. is that possible?

View 2 Replies View Related

Convert A Group Of Numbers To A Group Of Letters

Aug 9, 2006

My store uses a retail price "code" wherein a price like 99 in expressed as a
code like "PP"--exchanging the number digits 1-0 as letters.

Is there a function to do this automatically?

View 9 Replies View Related

Excel And VBA - Insert Group Of Cells Or Delete Them?

Apr 12, 2013

I am working on a contact information form for given relationships, and I'm trying to figure out the best way to design a button that copies the "form" (not an actual VBA form but a grouping of formated cells for information collection) and inserts it into the document. I would also like a button that deletes unused and empty forms so that we only print forms that are filled in.

I tried recording a macro to do it, but it's messy and creates issues with hidden rows and pagination.

View 4 Replies View Related

How To Check Whether A Text Exists In A Group Of Cells

May 5, 2009

What I want is to find out whether a value in a node can be found from a group of other nodes. I've tried lupike this, but it doesn't seem to work properly.


I guess one solution could have been using concatenate function, but why on earth can't I use the function like this: concatenate(A1:A5)? Why do I have to put each term individually?

View 11 Replies View Related

Copyrights 2005-15, All rights reserved