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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Print Active Cell Highlight
I have a routine that highlights a selected Active Cell, but when I printout the spreadsheet this highlight is not printed. I have been pull my hair out (what's left!), to try to show this highlighted cell when printed. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Range("d22:u45"), Target) Is Nothing Then Range("d12").Value = " Out" Range("e14").Value = "0" Else If Intersect(Range("d22:u45"), Target) >= 3 Then Range("d12").Value = Cells(19, ActiveCell.Column).Value Range("e14").Value = Cells(21, ActiveCell.Column).Value Static rngPrev As Range, PrevColor As Integer Dim TempColor As Integer TempColor = Target.Cells(1, 1).Interior.ColorIndex If Not rngPrev Is Nothing Then If PrevColor <> xlLineStyleNone Then .......................
View Replies!
View Related
Highlight Row Of Active Cell
Is it possible to have a specified shading (say 50%) applied to all rows except the currently picked row and the header rows to allow a user to focus on inputting across the row? I'd use this in conjunction with " Move Selection After Enter" to "Right" so the user would stay on the same row. I've tried the Help function, but can't find anything.
View Replies!
View Related
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 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
Highlight The Active Row
if you click on a row, it highlights every cell in it, I want to do the exact same thing but then also when you click on a cell only. Preferable (probably impossible though) without the use of VBA, because in my company I think some are "carefull" with enabling macro
View Replies!
View Related
Highlight Active Row
I spend a lot of time in spread sheets working with part numbers and sales figures. With a part # in column B and sales per month in adjacent columns, stretching back years. Is there any way to highlight an entire row automatically? ie. I use Ctrl F to search for a number and it goes to B24. I now want the entire row 24 highlighted as the active row. When I move to another cell I want the entire row highlighted automatically. Can it be done.
View Replies!
View Related
To Highlight Active Row And Column
I found this code to highlight the active row. I tried to make it highlight the row and column, but I was not successful. What I really need is to highlight the active row and column above and to the left of the active cell, not the entire row and column. For example, if G10 is active, the highlighted cells would be G1:G10 and A10:G10. Private Sub Worksheet_SelectionChange(ByVal Target As Excel. Range) Dim i As Long Cells.Interior.ColorIndex = xlColorIndexNone If Application. CountA(Target.EntireRow) 0 Then i = Target.Row Else For i = Me.UsedRange.Rows.Count To 1 Step -1 If Application.CountA(Me.Rows(i)) 0 Then i = i + 1 Exit For End If Next i End If Rows(i).Interior.ColorIndex = 6 End Sub Also, I have fill colors on the sheet and I just noticed that the code removes those fill colors. I need it to not remove my fill colors. The only fill colors it should remove are ones it previously colored.
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
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 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
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
Find Method To Search For The Active And Non Active Values
I have a range of amounts in Sheet 1 from F7:Q13 and im using the find method to search for the active and non active values in the cell. Which means that if there's a value in the cell it will transfer the value in Sheet 2, if nothing is found in the cell the cells in Sheet 2 will return as nothing or null. I think the problem lies on the FindWhat variable. Im getting a compiled error which im not sure what is it. I've attached the spreadsheet so you get a better idea of the problem that i encountered.
View Replies!
View Related
Identify Active Cell And Use The Column To Add Formula To Another Cell
I have a range of unlocked cells (B5:S10) that users enter data in. This sum of this data is then charted. The formula (sum) in a cell equals zero even when there is no data entered by the user. This zero is then charted. I need to be able to plot the zeros if the user enters zeros but not plot the zero if the cells are blank. What I was attempting to do is to use the worksheet change event to add the formulas to a cell so that the chart does not plot the value until something was added. In my change event I need to know that a cell in the range (B5:S10) was changed and that if it was D7 (for example) that I need a formula enterd in D11 [=SUM(D5:D10)]. If it was I5 then the formula would have to go in I11 [=SUM(I5:I10)].
View Replies!
View Related
Return Maximum Of Active Cell & Arbitrary Value To Cell
I am looking for VBA that will add the value of the current active cell on the sheet to the value in cell F12. The maximum value of F12 cannot exceed 1000. So if the value in F12 = 950 and 100 is the value in the active cell the maximum value in F12 should show 1000, not 1050. It should do this on the click of a button.
View Replies!
View Related
Selecting Cell A2 Will Highlight/change Font In Cell A1
How can I change the font color or highlight cell A1, when I select cell A2. Cell A2 is still blank, no value entered yet. I also would like cell A1 to return to original font color or no hightlight when cell A2 is no longer selected (active), whether a value is entered or not in cell A2. Let me clearify, (A1 thru N1) and (A3 thru N3) have diferent dates and the font color is white, as is the cell too. Therefor you can not see the dates in (A1 thru N1) or (A3 thru N3). However, when any cell (A2 thru N2) or (A4 thru N4) is selected (example A4), the cell above it (cell A3) changes font color or highlights, so the date can be seen in (A3). But when cell (A4) is no longer selected the above cell (A3) hides the date (changes back to white font on white cell). Data or a value is not necessarily entered into (A4) for (A3) to change. (A4) is only selected to show the date in (A3). But if data or value is entered into (A4), the date in (A3) will still be seen until (A4) is no longer selected/active.
View Replies!
View Related
Go To First Cell In List That Matches Contents Of Active Cell
I am just learning to use VBA and this may be the most simple task ever, but I can't figure it out. I've searched for all of the keywords I can think of, but can't find a solution... I have a list of names in a sheet. Other columns in this sheet contain data like amount charged, amount paid, etc. This sheet must be manually updated (because the other program won't export the information I need) periodically to ensure proper billing/payment application in the original software (all transactions are handled by other people that I don't trust). I sort the list so that the all names that are the same (ie John Doe) are together. A short example list looks like this: Jeremy Apple John Doe John Doe John Doe Jimmy Kravitz Jimmy Kravitz In updating my sheet, I set up a macro that will input todays date in one of the columns for all occurences of that name (so, every row that contains John Doe in column B, column V will have todays date in it). Currently, in order for my macro to work properly, I have to manually make the activecell the first occurrence of 'John Doe'. When I'm ready to update 'Jimmy Kravitz', I have to select the first occurrence of 'Jimmy Kravitz' and so on. Here's my question - Is there a way to use a VBA macro to find the first occurrence of 'John Doe' (and automatically 'know' which name I am updating)? Basically, I need a macro that will take the information that is in the cell in column B in the active row, find the first row that has that same name, and make that cell (column B) the active cell...
View Replies!
View Related
Add Active Cell Data To Cell By Clicking
I want to automatically put information from several cells into one cell, when these cells are clicked. Let's say that A1:J8 is the range were a cell can be clicked and if a cell is clicked in that range the value of these cells should be put in cell A9. If possible I want to avoid private subs in a worksheet. I preffer to have a macro running, so I can decide when to stop this routine.
View Replies!
View Related
Highlight A Cell
Have ABC row and EFGH row and just want to color the cells that only have double numbers in it....In Conditional formatting---- example---All are in separte rows--- ABC ------EFGH 123-------5544-----55red----44red 332-------4498-----33red---44red 212-------2132-----22-----22 just the doubles I need to color them RED---
View Replies!
View Related
Highlight Cell If Contains
i have a sheet which contains large data.All the cells as formated as TEXT e.g. value -863.45 appears as 0000-863.45 I have 3 types of values 1. headings => HEAD-1-TEMP-DATA 2. Only '-' sign => - 3. Numeric values with -ve sign => 0000-863.45 i want to hilight on Type3 values ..... is it possible with conditional formatting. Or any other way w/o changing any value in the original sheet?
View Replies!
View Related
Highlight The Cell
i have got a spredsheet, with clients names on it and in cell Q i have the clients account number, when iam looking at the clients name i also want to see the number, is there any way to highlight the cell i am on. What i mean isusing the arrows keys i want to make the row highlighted, is there a way to do this
View Replies!
View Related
Highlight Lowest Cell Value
I am new to excel and have to create a comparison chart that shows the lowest cell result in each row ie 23 25 28 13 42 16 13 21 34 25 17 21 23 17 I will have 36 rows by 20 columns I also need the lowest in each row to appear at the end of the row in the total column. I would like to highlight the cell by a cell colour rather than text colour.
View Replies!
View Related
Highlight Cell On CLick
Here is a selection of my data: [data] ...... Now here's what I would like to achieve. If I click or maybe double-click on a cell I would like the cell colour to change to lets say yellow. However, I would like all matching cells to change colour too. So from my example above if I clicked on C13 "3 TIMER" then C13 would change to yellow as well as C14 - C17 - C18 - C19
View Replies!
View Related
Function To Highlight The Cell That Is Different
I would like my function to highlight the cell that is different. I will be comparing 3 cells which should have the same value. What I would like to have happen though is to have the function highlight the cell that is different from the 3. Public Function Balance(A As Range, B As Range, C As Range) If (Abs(A - B)
View Replies!
View Related
Highlight The Part Of The Cell
Just "upgraded" my Excel to the 2007 version. In the old Excel, I could superscript part of a cell by highlighting the part I want, then going to "Format" and "Superscript." In Excel 2007, it doesn't work. Yes, I can highlight the part of the cell I want to superscript, I can right-click and select "format" and "Superscript", and it even then shows as superscripted in the cell. That is, until I hit enter or move to a new cell. Then the superscript is no longer there. The cell is in "general" number format. By the way, it did work in another cell: mg/l3 (3 superscripted) works. 742 (2 superscripted) doesn't work.
View Replies!
View Related
Highlight Cell Formula
I don't know if this can be done but I will ask you guys anyway On the attached, you will see what I want to happen If a user enters text into row "T" that contains "QIN" can conditional formatting highlight the cell in row N a solid colour if no numbers have been entered? As a reminder to users..
View Replies!
View Related
Highlight Minimum Cell In A Range
I have 4 cells and I want to highlight the lowest valued cell. At the moment I have the conditional formatting formula of =AND($C$5=MIN($C$5:$C$10),$C$5>0) However if C5 = 2 and C9 = 0 then C5 doesnt get highlighted as 0 is lower than 2. However I do want it to be highlighted. How can I ignore the zeros in the range im testing?
View Replies!
View Related
Highlight Cell If Same Value Exists In Another Column
I'm trying to do a formula without using a marco. The formula would do the following: - Highlight value in column A if the value is found in column B and on the same line value in column F and I are equal to zero; - Value in column A could match many value in column B I tried everything I know but can't seems to make it work.
View Replies!
View Related
Highlight A Row Based On A Cell
I have a macro that already works well but I need to make a change to it and I can't figure out how to do it. I need so when the macro is run it will prompt the user for a date. After they enter the date it will highlight cells A:K on each row that data appers. A little background for this. It is a schedule for a call centre which can show two to three weeks of schedules per agent. We rerun the macro each day to update break times and I would like it so it will highlight todays line.
View Replies!
View Related
Conditional Formatting (highlight A Cell)
I am working on a spreadsheet in Excel 2007 and i am trying to use a formula in the conditional formatting that will highlight a cell if the date is prior to today's date and the next column over is no. the formula i am using right now is =IF(F2>TODAY(),IF(G2="NO",TRUE,)). the problem i am having is that it is highlighting all cells that have a date and the next column over is no. i can't figure out how to get it to do an if this, then that function correctly. one other thing that could potentially be causing my problem is that the cells. I am trying to have highlight are calculated themselves based on a formula. see the attached spreadsheet for information.
View Replies!
View Related
Highlight Cell If Number Is Between Certain Range
Ive been trying to figure this out for a couple days with no luck. I have searched all over the internet but cannot find an answer. I have a series of columns, and at the bottom of each column I have a cell (which ill call the Total Cell) which automatically adds up the 10 or so cells above it. What I am trying to do is create a function so that if one of the Total Cells amount drops into the -1000 range Excel will highlight that particular cell or give an error or do something to draw attention to it.
View Replies!
View Related
Highlight Selected Cell When Using FIND
I have a worksheet with lots of data on it, resulting in a very busy layout. I have been using "FIND" to search for various numbers within the spreadsheet, however often times it is hard to see which cell "FIND" selects. Is there a way to enable Excel to highlight the selected cell? For example could "Find" turn the cell yellow when it finds a match?
View Replies!
View Related
Can I Make A Formula That Will Highlight A Cell
I have a large spreadsheet with many pieces of equipment in it. There are a few piece that I would like to highlight should thier computer license go out of date, or even better 30 days prior. I have a Feild with the Expire dates but it is at the end of the spreadsheet not in plain sight. Is there a way to make my Equipment description column highlight when the date in the other column reaches the current date (or 30 Days before). I have cut and pasted the part of the spreadsheet into a new file to make it easier to read and hid all the none important feilds.
View Replies!
View Related
BORDER Around Active Cell
I have a spreadsheet with DDE formulas in the cells. When the contents of any cell changes I want to DRAW A BORDER (NOT CHANGE THE BACKGROUND COLOR !!) AROUND THE CELL .. When another cell's value is updated I want to REMOVE the border which was around the"OLD" cell and now place a border around the most recently changed cell, etc. Only the newest active cell should have a border around it !!!
View Replies!
View Related
Active Time In A Cell
is there any way to have a running clock or time in a cell like when you open up a sheet you see it click-by second by second I would like this, so when i print the sheet it shows exactly what time it was when printed
View Replies!
View Related
Active Cell And Offset
ThisWorkbook.Sheets(2).Cells(nrow + 1 + j, 2 + high_count).Formula = "=VAR(" & ActiveCell.Offset(0, n_high_count -1) & "," & ActiveCell.Offset(0, -1) & ")" *n_high_count is the negative of high_count I want "ThisWorkbook.Sheets(2).Cells(nrow + 1 + j, 2 + high_count)" to have the formula "=VAR(XX:XX)" where the range is the current row second column to the current row current column -1.
View Replies!
View Related
|
TRACKER
