Highlighting Row
I am interested in finding out how I can highlight the row I am currently working in? When I move rows, I want the highlighting to move to the appropriate row.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Highlighting Active Cell's Row, Along With Any Row That Shares Same Value In That Column
Is it possible to click on a cell in column C, and have the wishlist below happen: That active cell's row is hightlighted. Any cell in that column that has the same value as active cell is also highlighted. Plus, any cell in another sheet that has that value it's row is highlighted too. Example: I click on C5 in Sheet 2 its value is 45000789 it row is highlighted, this value also appears in C3 in the same sheet, so it's row is highlighted as well. Plus, in sheet 1 in C10 this value appears and it's row is highlighted as well. When any of the values are clicked again the highlight is removed from all parties.
View Replies!
View Related
Highlighting Entire Row
This problem has been driving me insane, as I thought it wasn't possible to do in excel however this morning I accidentally pressed a shortcut key on my keyboard and what I wanted, happened.. pity I can't remember how I did it. How do I highlight an entire row, but remains highlighted when i enter info in the cells until i move down to the next cell? Eg. I click on row"1" so that all cells are highlighted, then while entering info in B:1 - the entire row is still highlighted? This will be very useful in my line of work. I know there was some information on conditioning formatting, but surely there is a way to do it via keyboard shortcut since i accidentally did it just before.
View Replies!
View Related
Highlighting The Row With The Selected Cell
I work with many sheets that have many data columns and have used a "greenbar" formula in conditional formating but would like to have a similar formula that highlights the current row. If possible, it would be nice if this new formula would not wipe out all other formatting as it moves. I have seen Ivan's work at www.mrexcel.com/hof001.php but it says that it wipes out other formatting. The formula that I am currently using is =MOD(ROW(),3)=2 Is there a way of getting the current row number so that it could be =ROW()=(current row number) ?
View Replies!
View Related
Highlighting A Row And Having That Data Tranfered To Another Worksheet
I have 1 Excel Doc that has 3 worksheets (DATA, COVER, TPA). DATA is where i input the data and COVER and TPA are where the data needs to end up. both COVER and TPA are standardized sheets that i do not change...only the data coming in will change. How can i make it so that whatever row in DATA i highlight, that row's data will be entered in to the correct spots on both COVER and TPA. when i highlight a different row, then the data will change to that row's data in both COVER and TPA (hope i'm explaining this correctly). right now i can only do 1 row by using (=DATA!$D$2). basically i want the '2' that is representing the row to be whatever row i have highlighted. if i highlight row 51 i want the formula to read (=DATA!$D$51). can anyone please help. i can put up a copy of the spreadsheet if need be, i am just hesitant cause of the confidential info. i would need to change the names and numbers to protect the innocent.
View Replies!
View Related
Select An Item Of Data ( Or Update A Particular Cell ) Then I Loose The Highlighting For That Row
I have a big spreadsheet that has 30 columns. The data is downloaded from an SQL database from time to time. The row identifying data ( the record number/key ) is in the left most cell. I often have to move over 10 to 20 columns to view some other data in the same row. I can do this by selecting the preset Excel row number which higlights the whole row and then use the lower slider bar to go to the correct column to view the data. However if I wish to select an item of data ( or update a particular cell ) then I loose the highlighting for that row and I can "loose" which row I am on. ( maybe I'm stupid but it does happen ) Can I use Conditional formatting to highlight a row whenever I alight on any data in that row and it sttays highlighted until I select another value on another row?
View Replies!
View Related
Highlighting Data
I have a spreadsheet that I need to highlight the last row next to the name in column E where the date in column C is 35 days or less than the current date in cell A2. For eg if there are 10 names containing the name "James" in Column E and the last date in column C (say C20) in line with James is 35 days or less than the current date in A2, then the entire row from A to G for eg A20:F20 must be highlighted in grey. I need VBA code that will do this for me. I have attached in sample spreadshhet. In the attached example A14:G14 and A16:G16 must be highlighted in grey
View Replies!
View Related
Highlighting Within A Sort
how can I highlight any value that is duplicated within the same sorted value? Example: I sort column B so that all the names are in order. In column F I want them to be highlighted when there is duplicate name within the same sorted names of B.
View Replies!
View Related
Highlighting Big Changes
I've a large spreadsheet packed full of values, and % variences etc etc My boss has tasked me to try and highlight each week the major changes from the week before. The whole spreadsheet is full of vlookups based on a cell - Z3 in this case. Cell Z3 is a week number, and when i change that, everything is updated based on a load of other sheets. Is there a quick and easy cheatuing way using some code that i can analyse all the changes from what the values were before, to what they are now, and highlight the major movers?
View Replies!
View Related
Highlighting And Printing ...
I have attached a sample sheet which is for invigilation of exams. In columns D, E & F are the initials of people invigilating at different times. What I want to able to do is to print personised sheets for each person where there initals are in bold and the box has a black border around it. This is very labour intensive if I do it manually as have to highlight one person, print, unhighlight and rehighlight the next person and so on. What I was wondering is could I use a macro to automate this process. So it has a list of all the initals and it searches through and highlights the person and prints it and then moves onto the next.
View Replies!
View Related
Highlighting Rows ..?
I have a spreadsheet with one column. For example, it contains A A A A B B C C C D D I want to highlight the A's and don't highlight the B's and then highlight the C's and then don't highlight the D's and so on. I want to highlight or not highlight the entire row.
View Replies!
View Related
Highlighting A Link
I have created a data base of all the spare parts we have at work. In the last column I have entered a hyperlinks that take you to a layout of the store and shows you where the part is located i.e. – 1C would take you to shelf ‘1’ level ‘C’ on the drawing in another tab in the same Excel workbook. I would be pleased if anyone could help me by suggesting away that I can make the destination cell highlighted or more prominent once you have clicked on the link. Also can I make the Find window automatically appear when the workbook is first opened?
View Replies!
View Related
Highlighting A Certain Value In A Column
i am trying to get a VBA to find the value 'TRCO' select the row and highlight the row in red, i have tried the way below but i get an error saying 'type mismatch'. If Range("b7", "b51166").Value = "TRCO" Then Rows.Select Selection.Font.ColorIndex = 3 End If
View Replies!
View Related
Highlighting For Duplicate Entries
I would like to check column B and if any of these values match values in column J hightlight the cell on the same row as the match on column E green. I don't know much about excel but this would be a tremendous help because i'm looking through quite a bit of data. I've tried using conditional formatting and i can't seem to get that to work for my needs. Let me know if you need anymore information.
View Replies!
View Related
Highlighting More Rows Than I Want To - How To Stop Please
I am using a 2007 excel spreadsheet and on parts of it I can't just highlight one horizontal row of cells, it wants to highlight three down. I suppose that I have asked it to do this but I can't for the life of me undo it. I have tried unmerging cells, cutting and pasting somewhere else, but nothing works. Can anyone help me please as it's driving me to distraction?
View Replies!
View Related
Highlighting Active Field
Using excel (i think its 2000, work PC they are behind the times) and i was wondering if there is a way to automatically highlight the active field as i move around the cells. It would be easier to see where my cursor is.
View Replies!
View Related
Highlighting The Odd Value In A Column
I have a worksheet, the data flows from different columns, like a,b,c and the result is in d column. The entries are spread from 1 to 45 rows. The format of data is five digit number. As I have formatted the cells as "custom" like "00000", the Zero is shown on left side, but when the column is copied/pasted in another column in certain entries zero disappears. Is there any way to get the 4 digit entries, highlighted, so Zero can be added on left side manually directly to the concerned entries, instead of checking each and every entry.
View Replies!
View Related
Highlighting Specific Cells
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 Replies!
View Related
Highlighting Same Postcodes In A Spreadsheet
I run a delivery business & work comes in bit by bit by postcode. I thus enter the postcodes into my spreadsheet. Then when it comes time to process the work I'm wanting to be able to do something that will highlight all postcodes that match the same colour. I posted this query on another forum & a helpful guy gave me the code below which worked a charm, but only for a while. Since then I have slightly tweaked the spreadsheet, taken a couple of fields off & added a couple. The code now hardly works or if it does will only do one column or row & not the complete spreadsheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim oDn As Integer, oAc As Integer, Dn As Range, oPC, nDn As Integer, nAc As Integer, Ac, c, p Dim Rw1 As Range, Rw2 As Range, Rw3 As Range, Rw As Integer If Target.Address(0, 0) = "A1" Then Set Rw1 = Range(Range("E2"), Range("e" & Rows.Count).End(xlUp)) Set Rw2 = Range(Range("G2"), Range("G" & Rows.Count).End(xlUp)) Set Rw3 = Range(Range("I2"), Range("I" & Rows.Count).End(xlUp)) Rw = WorksheetFunction.Max(Rw1.Count, Rw2.Count, Rw3.Count) oPC = Range("E2:I" & Rw + 1) c = 2 For oAc = 1 To UBound(oPC, 2) For oDn = 1 To UBound(oPC, 1) If Not oAc Mod 2 = 0 Then If c = 25 Then c = 2 c = c + 1
View Replies!
View Related
Auto Highlighting Cells
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 Replies!
View Related
Highlighting Filtered Columns - Automatically
I have been trying to find a way to highlight columns that are filtered in Excel. On a laptop it is not always that easy to tell which columns are filtered. I have found a piece of VBA that can do this (see http://www.vbaexpress.com/kb/getarticle.php?kb_id=365). I would like to do two things: 1. Have this run whenever an autofilter is changed (a new filter chosen or a current filter changed). 2. Have this effective for every workbook that I open. I'm hoping that someone can help a VBA newbie sort this out.
View Replies!
View Related
Highlighting ARRAY Formula Cells
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 Replies!
View Related
Finding Sequences And Highlighting Them In Different Ways
how to go about finding sequences and highlighting them. here's an example list: 7600 7601 7602 7603 7604 7608 7609 7610 7611 now i need to find 3 things in this list. 1) how many 'batches' of sequences there are in this list. The numbers 7600 to 7604 are a consecutive sequence of five numbers followed by another sequence from 7608 to 7611. that makes two sequences. i need a formula for one cell that would specify how many sequences there are in a given list (in this case they're two sequences in this list). 2) is there any formula that can allow me to see each sequence highlighted in a different color (or any way to differentiate the sequences so i can copy paste them easily?). Pretty sure i'd have to use conditional formating on the entire list to do so but am clueless as to the implementation. 3) a formula for a single cell that can state the largest sequence in the list. in the list above the largest seuqnce is 5 numbers so that would be the value i'm looking for.
View Replies!
View Related
Highlighting Max & Min
I have a column "A" with a cell for each week's income (A-1 thru A-52). Is there a way to program these 52 cells so that the cells reflecting the "maximum" and the "minimum" amounts of weekly income, would be automatically highlighted in some way? Of course the "minimum" would have to be able to not use the cells representing the weeks that have not occurred yet. These cells will also need to be able to change automatically as weekly income amounts change.
View Replies!
View Related
Highlighting If A Range Of Cells Meet A Value
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 Replies!
View Related
Highlighting The Active Cell After A Highlight
I have a cover sheet to a workbook that holds hyperlinks to its relevent page. Several of the hyperlinks link to the same page but different relevant cells. However it is not overly clear which cell is active when you click the hyperlink. What I would like is for the active cell to be highlighted on the page. EG hyperlink 1 links to page 1 cell A2 & hyperlink 2 links to page 1 cell B6 - I would like A2 to be highlighted when accessed by hyperlink 1 & B6 highlighted when accessed by hyperlink 2.
View Replies!
View Related
Highlighting Or Deleting Specific Cells
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 Replies!
View Related
Highlighting A Cell, Based On Value / Blank.
I have a macro, and it mainly works, except the second part where it checks if the value is less than 7, and returns it to a white background. The cell has a formula in it that returns "" based on another series of cells. I have considered changing that to a zero and formating, but for reasons that don't need explanation, i have chosen not to. here is the macro. I need the second part to be activated if less than 7, as well as if the cell returns ""
View Replies!
View Related
Finding And Highlighting Duplicate Names
I have two columns that is use to record last name first name. I need a macro that will find matching names in the columns. i have found some examples for searching one column but have not had any luck finding someway to do 2 columns. in the example below i need it to find and highlight The names Smith John.
View Replies!
View Related
Highlighting Saturdays And Sundays In A Column
I am running Excel for Mac V2008. My spreadsheet has various columns with column A representing dates of a 6 month period formatted as: ddd d-mmm-yy, one day per cell. I want to highlight the cells which are Saturdays and Sundays and are not working days for my Plant. I think it may be done using conditional formatting, but I have been unable to discover the right formula which would allow this to happen.
View Replies!
View Related
Highlighting Cells Depending On A Value In Another Cell
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 Replies!
View Related
Highlighting Mulitple Cells With A Macro
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 Replies!
View Related
Highlighting The Auto Sum Section
When autosuming a section of a column, is it possible to conditional format a highlight of the 'autosumed section' so i can visually see where it is at all times?? (i.e. so when i autosum, automatically a highlight will appear over the autosumed section)
View Replies!
View Related
Highlighting Range Of Cells In VBA
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 Replies!
View Related
Conditional Formatting Of Dates - Highlighting Of Columns
Well I spent some time yesterday trying to figure this one out. It was only last week that I have taught myself how to use VBA in excel. However this looks like a though one. Simply what i would like to do is highlight a column of a certain date (till a certain row number) based on a list of dates. eg. Across the top I have a set of dates and on another sheet i have a list of dates. I understand that there is a VBA code for such conditional formatting but i can't get my head around it.
View Replies!
View Related
|
TRACKER
