Highlighting Cells Related To A Cell

Jul 14, 2009

in this sheet i have 3 groups of data. group 3 is the sum of group 2 - group 1.

how can i make the cells highlight that relate to the cell sum in group 3.

i.e when i click cell b38 cell b21 and b4 should highlight.

View 9 Replies


ADVERTISEMENT

Highlighting Cells Depending On A Value In Another Cell

Aug 19, 2006

Have a spreadsheet shows 4000 warehouse locations (location of products). Each cell is a location in the warehouse (ba050, ca809, etc, actual warehouse locations, not grid ref); some products have more than one location, the locations are always next to each other. I import a text file into the workbook which tells me which product has more than one location (2, 10, 50, etc), that’s all I’m interested in ( multiple locations).

What I’ve done so far is to use vlookup to look at locations in file and allocated the number (the number of locations that product has) next (next column) to the cell that correspond to that location. What I need is a macro or formula that will look at the number and than highlight that many cells up or down the column, according to the number in the cell to the right (5 in cell, highlight 5 cells, 50 highlights 50). The warehouse runs up one aisle and then down the next and so on. So I need to be able to highlight cells up one column and then down the next and then up, then down and so on.

Multiple locations change on a daily bases, so need a quick way of updating 4000 locations.

New to excel don’t know if this is possible or not. Learning as I go.
Need some assistance.

Sample below.
Only interested if a number is returned, “******” can be ignored as will hide all columns expect ones with locations. So:

BA020 returned value of 4, so would like to highlight (any colour) BA020, BA029, BA040, BA049.

BB780 returned value of 2, so would like to highlight BB780, BB789.

POSSIBLE?

BA090 2 BA100 **** BB749 **** BB739 ****

BA079 **** BA089 **** BB760 **** BB750 ****

BA070 **** BA080 **** BB769 **** BB759 ****

BA059 **** BA069 **** BB780 2 BB770 ****

BA050 **** BA060 4 BB789 **** BB779 ****

BA039 **** BA049 **** BB800 **** BB790 ****

BA030 4 BA040 **** BB809 **** BB799 ****

BA019 **** BA029 **** BB820 **** BB810 ****

BA010 **** BA020 4 BB829 **** BB819 ****

View 9 Replies View Related

If Formula - Look At All Eight Cells Related To These Courses?

Jun 19, 2014

got a formula that checked C4, then D4 for dates (either in or our of date) and returns a count of 0 or 1, with some cells having tet in them also.

The formula I am currently using is below

=IF( OR(F4 ="enrolled",F4 = "O/S"),0, IF(AND(G4="",TODAY()-F4>730),0,IF(AND(TODAY()-F4>730,TODAY()<G4),0,1)) )

I have a range of four courses (all child protection) that should be attended, some are eleanring, some local authority courses and staff should attend at least one but up to all four of them. Although they all fall under the question are they compliant or not (i.e.0 or 1)i do not want to count them all seperately. Is there any way I can look at all eight cells related to these courses and assess the latest date to assess if they are complinat (in date) or non compliant (out of date)?

I have attached the spreadsheet which I hope will clarify things

=IF(AND(E4="",TODAY()-D4>730),0,IF(AND(TODAY()-D4>730,TODAY()<E4),0,1))

View 8 Replies View Related

Look Up Value And Return All Related Values From Other Cells

Jan 8, 2009

I have two worksheets. One contains my master data and the other my look up table.

Master Data: ....

View 9 Replies View Related

Event Trigger And Format Related Cells

Sep 20, 2012

Is it possible to write an event trigger macro to format cells? Let's say I want to add a new information to the row which is after FinalRow. Can I force excel to detect the input and then format that new row as previous rows or something custom?

View 4 Replies View Related

Excel 2010 :: Disable Something Like Text Box Related To Cells?

Aug 4, 2014

I am using excel 2010. When I click on cells on one column, something like text box will pop up with information related to that column. How can I get rid of this text box. How to disable this text box which I think it has a link between the text box and cells on that column.

View 1 Replies View Related

Highlighting Lowest Score Without Duplicates Highlighting And Counting Player Skins?

Feb 15, 2013

I found this spreadsheet on here and I have been trying to customize it to what I need. I am trying to have scores from skins match highlighted. I want only the minimum score to be highlighted but if there is another duplicate minimum score I don't want it to highlight anything. I also need to find a way to count the skins won by each player and have it off to the side.

For those not familiar with golf a Skin is a game where you try to get the lowest amount of strokes on a specific hole. Ex- 4 people play the hole one. P1 scores 4, P2 gets a 3, P3 and P4 get 6. The skin would go to P2 who has the lowest score on that hole.

Highlight lowest number in each column not highlighting if there are duplicates starting at L6 down to L11 and for each column till AC. And the same for the group just to the right on attached file.

On row 13 and 14 it tells me who won a skin. I want to tally up the total skins won by each player. so if Joe's names shows up twice on R14 I want it to tell me somewhere in the sheet Joe = 2

View 6 Replies View Related

Highlighting Cells If Specific Data Appears In Adjacent Cells

Mar 18, 2014

I have a couple of spreadsheets that has several columns each containing several hundred thousand rows of codes. To quickly analyze this data, I am trying to come up with a conditional formatting formula to highlight the respective cells when specific values occur next to each other. A particular code will show up in many cells, but the code that is the respective adjacent cell is always different. I need to know when row A contains, for example, '9928559' and row B contains '36415RT'.

View 3 Replies View Related

Highlighting A Range Of Cells Dependant On Data In Any Of Those Cells

Jul 20, 2009

On the attached sheet I am trying to indicate that enough data has been entered by highlighting the entire column. Any 3 cells in Rows 7-13 and 18-36 will be filled in with any of the values from cells O6-O11 (hidden). When the total = 6 i would like to highlight the entire column to indicate it has been completed.

The aim is two fold: to ensure that the correct number of points is allocated in each race, and secondly to indicate which column is the next to be filled in (as human error sometimes misses the column and adds the points to either the previous or next columns). You could call it idiot proofing the sheet. At present i have the cells in Row 37 conditional formatted to show this, but would much prefer the entire column to highlight.

View 2 Replies View Related

Auto Increment Specific Cell Value Based On Different But Related Cell Value

Nov 20, 2011

In my excel workbook, I have a customer table and invoice sheet among many others.

As part of my system, there is functionality to grant new customers with a discount on the first purchase. Within my customer table, the last two columns are "Number of Purchases" and "Customer Type" (either single/multiple depending on no. of purchases), which are then used to determine whether the discount is valid or not on the invoice.

Once an invoice has been created, archived and refreshed with the customer selected (via a Customer ID), I would like some code to auto increment the number of purchases on the Customer table for that specific customer to +1.

For example, customer called Bob (Bob-1);
Number of purchases = 1
Customer Type = Single
Discount = Yes

Invoice then created for Bob (using Bob-1 as the unique value), sent off and refreshed. New figures should be:

Number of purchases = 2
Customer Type = Multiple (can be achieved by using IF statement on No. of purchases)
Discount = No

View 1 Replies View Related

Highlighting Cells Based On Cells Values In VBA

Mar 26, 2007

I need to highlight a cell when its value exceeds parameters based on the production line it comes from. If the line is K11, then i need this cell to highlight when its value is either < 0 or greater than 221. If the line is K21, than it needs to highlight when its value is <0 or greater than 474.

View 9 Replies View Related

Highlighting Matching Cells

Apr 11, 2008

im looking for a formula that will find matching dates in column a and then i want to see if column b has a matching time in it

View 11 Replies View Related

Highlighting Specific Cells

Feb 11, 2009

this seems like such a simple thing to do but I just cannot suus it out. Basically I want to Highlight a cell depending on another cells value:

ie. I have a value in Cell A1 and a value in Cell B1, in Cell C1 I have an IF statement that dsplays the word 'NO' if the values in A1 & B1 are not equal. In Cell D1 I have the word Fault. I would like to highlight Cell D1 if the Cell C1 displays the word 'NO'

View 3 Replies View Related

Highlighting Range Of Cells In VBA

Jun 9, 2006

What is the line of code in VBA that allows me to highlight a range of cells (in a column) to the end of the range? e.g. Selection is A2, highlight to end of range in column A. I know this is simple, but I'm new to VBA. Unsuccessful searching the posts.

View 2 Replies View Related

Auto Highlighting Cells

Jun 8, 2007

Is there a way to automaticaly highlight multiple cells if there is data in two other cells else were? What kind of programming will I have to use. I.E. highlight cells D1:E15 only if there is data in cells A:2 & B2

View 3 Replies View Related

Filtered Listbox Selection To Return Value To Related Cell?

Apr 30, 2014

See the attached : ToolMatrix4.xlsm

Combobox2 filters listbox2 which is pulled from sheet2. How do I get the X to return the value to the relevant cell on sheet 2, ie create a relevant listindex for the listbox

Also, one other minor thing, why selecting the last record in the listbox doesnt write to the worksheet?

View 4 Replies View Related

Put Message Box Related To A Cell If Threshold Values Reached

Mar 25, 2012

I am trying to put a message box related to a cell if a threshold values is reached.

E.g.: Cell A: 85

If cell A values moves to 86 I am trying to put in a message that says something like " This value is not allowed". Is there a way to do this ?

View 8 Replies View Related

Automatic Highlighting And Expiration Of Cells?

Jun 12, 2014

I have a large document control register and it is updated daily and posted to a cloud for many people to access. It is very time consuming to constantly jump in and out and highlight and unhighlight as many things as there are and keeping track of which items that need to be unhighlighted. The thing I'm trying to figure out is if there is a formula for this...If i change any cell in a row I want the row to highlight itself entirely, but after 24 hours I want the highlight to expire. Is there a formula or function I can use to make this happen?

View 4 Replies View Related

Highlighting If A Range Of Cells Meet A Value

Jan 19, 2008

I have a worksheet 200+ rows with 7 columns (euro lottery numbers) I had great help last night to highlight any matching numbers. I'm getting lazy now, can anyone help with a formula to highlight a cell in an adjacent column when 2 or more numbers in the corresponding cells match the winning numbers, I know all I have to do is look down the columns and check but if a simple formula could be inserted it would save me perhaps missing something.

View 14 Replies View Related

Highlighting Or Deleting Specific Cells

May 16, 2009

I have Column A with 380 cells filled in with numbers (A1-A380) i.e. numbers like..456758, 567848 etc etc

Column B has a subset of those numbers, maybe 80-90 or so (B1-B90).

What I want to do is either highlight the numbers in Column A that also appear in Column B in yellow, OR delete them from Column A altogether

View 8 Replies View Related

Highlighting The Cells Using Conditional Formatting

Aug 19, 2009

Is it possible to highlight a1:h1 if cell a2 contains dark?

i used this code in cell i1-->=MATCH("dark",a2,0)

and i dont know what's next, my friend in the office told me to use conditional formatting.

View 2 Replies View Related

Highlighting Protected/Unprotected Cells

Jan 28, 2008

The Special GoTo function doesn't have a listing for highlighting (going to) only protected or (preferribly) unprotected cells. Is there an easy way to do this?

View 9 Replies View Related

Highlighting Duplicate ALL Cells On A:A Column With Red

Jul 17, 2008

I'm use with this macro to Highlight duplicate cells BUT the macro highlight only from the second duplicate

I need to highlight ALL duplicate cells in column A:A .

FUNCTION like " =COUNTIF($A$1:$A$11,A1)>1 " it's not good for me in this case, i need it with a fast macro

View 9 Replies View Related

Highlighting Mulitple Cells With A Macro

Nov 6, 2009

I need to highlight cells for all of the products and rates I need to get pricing for. I have a macro that goes out to my data and pulls in each different rate and program (columns BM:BN). That macro also sets the first note rate in the range to the lowest of the group, so this will always be different.

I now manually highlight each cell that I need to get pricing, but would like to create a macro that looks up those codes and rates in column BM:BN and highlights the cells for me. I need it to highlight in all 7 boxes. I've attached a sample worksheet of what it looks like after I highlight the cells.

View 2 Replies View Related

Highlighting Cells Based On Several Conditions Using VB?

Feb 27, 2013

I am writing a data validation macro which checks various conditions and highlights cells if they are incorrect.

i.e. If cell in column D = "specific text", then cell in column AH of the same row must = "specific number". If it is not that number, colour the cell red. If another cell in column D = "another specifci text", then cell in column AH of the same row must = "specific number". If it is not that number, colour the cell red.

What I've found is that I can get one condition of this nature to work, but if I run two or more in the one macro, that they supercede eachother (and thus the final one is the only one that works).

See below sample code.

Code:
Dim val As Integer
val = UsedRange.Rows.Count
For i = 2 To val Step 1

[Code]...

View 4 Replies View Related

Highlighting Row (specific Number Of Cells)

Sep 25, 2013

Any method for colour highlighting a row (specific number of cells) as and when any cell of that row is selected, and return to normal when deselected.

View 4 Replies View Related

Highlighting Column And Row Intersection Cells

May 1, 2008

Any code or formula to highlight the intersected cells between a column and a row for any selected cell ?

Ex: if i select E25 the cells of column E1:E25 as well as the cells of Row A25:E25 to be highlighted in a certain color , and so on for any selected cell..

View 9 Replies View Related

Highlighting ARRAY Formula Cells

Aug 8, 2006

Essentially I have inherited a spreadsheet which is crammed full of complex array formulas.

No problem in itself as I understand array formulas pretty well (or so I think!). My problem is that when i want to ammend some of these, i cannot easily see what range I need to highlight in order to edit them i.e. I obviously cant do a single cell as its part of an array. I hope I have made myself clear?

So my question is this.

When the cursor is sat in a cell that is part of an array formula, how can I easily find out ( ideally by the array formula range being highlighted in (say) red ) what cells are included in the array formula?

Would conditional formating do the job?

View 9 Replies View Related

Excel 2007 :: Comment Boxes Not Showing To Near The Related Cell?

Dec 9, 2012

I have worksheet with 5000 rows data's including the comments in one coloumn.My problem is when I edit the comments,the comment box shows somewhere else is not showing to near the related cell.I am using excel 2007,its happen after the upgradation of 2003 to 2007.

View 2 Replies View Related

Pick Data From A Specific Row/column (eg 10/B) Related To Active Cell

Dec 2, 2009

I have a spreadsheet with my Periods along row 10. e.g. C10: "1", D10: "2", E10 "3", F10: "4", G10: "5" etc. (green on the attached sheet). I have my departments along column B, e.g. B11: "Baked" B12: "Fresh" B13: "Frozen" (yellow on the attached sheet)

what I need and cannot work out is some VBA code that will populate two variables (lets call them Period & Department) when I click on one of the figures. For example if I click on cell: if I click E14: Period would have the contents of cell E10, and Department the contents of cell B14.

if i click G14: Period would have the contents of G10, and Department the contents of cell B14 again. I know how to get the click on the cell to work properly etc, and I have code to slot these variables into that works very nicely, I just can't get this bit to work!!!!

View 2 Replies View Related







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