Highlight Row And Column Of Active Cell In Large Spreadsheets

Apr 4, 2013

Is there a way to highlight the row and column of the active cell? The highlighting will move as the active cell is moved around the spread sheet. I have a newbie manager that is bugging the pea-turkey out of me! He wants to be able to easily see where he is within some of our sheets while he is in a vehicle or outside on a job site...seems like an "accessibility" type issue, but can't find anything in Excel "Options."

View 5 Replies


ADVERTISEMENT

Sum Of Columns If Values Of One Column Are The Same - For Large Spreadsheets

Apr 15, 2014

I'm in need of a formula that can give me the sum of cells in a column if the values in another column are the same. For example:

Col A
John Smith
John Smith
John Smith
Jane Doe
Jane Doe
Jane Doe

Col B
2
8
9
3
4
6

Col E
Monday
Tuesday
Sunday
Monday
Wednesday
Friday

The total for John Smith would be 19 and the total for Jane Doe would be 13. The problem is that this file is huge and we will have to use this formula on a weekly basis with different values each week, so it would be very difficult to use a "specific" formula for each person. Is this a possibility?

And to make it more difficult, I would then have to subtract one of those values if that row has a certain value in one of the other columns.

If values in Column A are equal to each other, sum of Column B. (Column C would contain the sum in this case.)

Column D = Column C minus B, if value of Column E is Sunday, otherwise don't subtract anything.

The total for John Smith in Column D would be 10 and Jane's total for D would still be 13.

View 10 Replies View Related

Highlight Column And Row Of Active Cell But Retaining Previous Formats

Feb 28, 2014

I have found this code by searching witch is perfect

Code:
If Target.Cells.Count > 1 Then Exit Sub
Application.ScreenUpdating = False
Cells.Interior.ColorIndex = 0
With Target 'With the cell that was selected,
.EntireRow.Interior.ColorIndex = 8
.EntireColumn.Interior.ColorIndex = 8
End With
Application.ScreenUpdating = True

The point is that i want to retain the previous formatting of cells when i select another cell. And also i would like to create a switch to turn the Worksheet_SelectionChange event on and off. The tricky part is here i guess, becouse i would like when turned off to retain the previous formatting also.

View 2 Replies View Related

To Highlight Active Row And Column

Jan 6, 2008

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 9 Replies View Related

Excel 2003 :: Highlight Cell On Same Row As Active.cell Whenever Active.cell Changes

Dec 10, 2012

whenever the active cell is within a given range, highlight the cell on the same row in column S (by changing its interior colour). This should occur each time the active cell is changed, whether by cursor keys or mouse. The effect would be similar to the row and column highlights at left and top of the worksheet.

This action should be restricted to one sheet in the workbook.

It's for Excel 2003.

View 3 Replies View Related

Highlight Active Cell Only?

Jun 8, 2014

Need to have only active cell in in any worksheet highlighted or formatted in a different way than other cells

View 1 Replies View Related

Highlight Row Of Active Cell

Oct 27, 2008

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 3 Replies View Related

Temporary Highlight Row Of Active Cell

Nov 18, 2010

When looking at a spreadsheet with many columns, it would be nice of the row of the cell I have selected would remain highlighted in yellow, so that as I scroll across rows it's easy to view the data associated with the selected cell. Of course, if I select another cell, I would want the highlighting to change to THAT row. I'm guessing this would have to be in a this.workbook change event.

View 9 Replies View Related

Active Cell Highlight Missing

Feb 22, 2010

When I open any spreadsheet (new or already populated) the black box that normally frames the active cell is missing (showing which cell you have selected). Likewise when I 'select all' the sheet does not become shaded.

In addition:

Cannot fill series
Cannot change cell format (specifically to show Currency or Accounting w/$ symbol)

View 4 Replies View Related

Highlight Active Cell Or Cells

Jan 14, 2014

Is there something built in to excel that highlights the cell or cells that are currenyl selected and then not save any highlighted cells when the sheet is saved. Maybe if not something that is built in but a vba script?

View 1 Replies View Related

Highlighting The Active Cell After A Highlight

Nov 30, 2006

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 9 Replies View Related

Print Active Cell Highlight

Nov 14, 2006

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 9 Replies View Related

Change The Background Or Highlight (instead Of Bold Border) The Active Cell

Jul 4, 2007

As i navigate excel, I was wondering how to change the background or highlight (instead of bold border) the active cell?

View 3 Replies View Related

Find Like Numbers Over Two Spreadsheets And Highlight

Mar 16, 2014

I have two spreadsheets. Spreadsheet 1 has 6 columns and column E has a list of numbers. It runs from E2:E739.

Spreadsheet 2 has 9 columns and column A has the numbers I need matched against. Column A runs from A9:A5027. How can I find the numbers from Spreadsheet 1, Column E that are also in Spreadsheet 2, Column A. Once matched I would like to highlight the ROW on spreadsheet 1 that has a match.

View 3 Replies View Related

Comparing Spreadsheets And Highlight Any Errors

Jun 11, 2009

I have 3 spreadsheets that should be exactly the same - with the same data and same positions - is there a way of comparing all 3 to see if this is true and highlight any errors - either by using a master sheet or some kind of conditional formatting

View 7 Replies View Related

Highlight The Active Row

Dec 21, 2006

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 9 Replies View Related

Highlight Active Row

Oct 2, 2008

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 9 Replies View Related

Convert Column Headings To Cell Value In Large Spreadsheet

Mar 12, 2014

I have a very large spreadsheet that is a consolidation of approximately 105 separate of contacts lists. The new consolidated spreadsheet contains demographic data, and a column for the name of each of the 105 lists. Each contact in the consolidated list had an "X" placed in the column if they were a member of that particular list. Each contact can be in more than one list. This is not very useful for me.

Here's a visual representation of the current list along with what I need:

FName
LName
Address
Phone
City
List1
List2
List3
List4
List5
List6

[Code] .....

I would like to add a column to the spreadsheet and call it "Source"

And then have a macro or VB script to do the following:

1. As shown above, put the column name (ie "List2") in the "Source" column whenever there is an "X" in that row for the corresponding Column.
2. Because each contact can be in more than one list, I need to append the column names so that "Source" column contains all of the column names (Lists) that had an "X"
3. Once all of the list names have been added to the "Source" column, I will delete the list columns.

View 1 Replies View Related

Go To Last Active Cell Column

Apr 7, 2009

I have a macro where I sum a large number of cells in column AZ. How can I have the Macro end in the last cell of column AZ where the sum is located? The length varies in each file.

View 3 Replies View Related

Highlight Cell In Column When Compared To Each Value Of Another Column

Jun 25, 2014

Formula to highlight a cell in a column when compared to each value in another value. If I have the columns

A B
1 1
1 2
2 3
3 5
4 7
7 8

I want the values in column A to be highlighted if the excist in column B, both of the number 1:s.

View 4 Replies View Related

Find SECOND Last Active Cell In Column

Jan 15, 2010

I use the Index/Match formula to find the last active cell in a column quite effectively.

I'm wondering though how to adapt it to find the second last active cell?

EX: Last active cell formula:


Data:
a 10
b 11
c 0
d 12

View 10 Replies View Related

Select Top Cell (row 1) In Active Column

Apr 23, 2014

I want a simple macro which will go to the cell in row one in the active cell's column

View 2 Replies View Related

Moving Active Cell In Same Row To Column A

Jun 28, 2009

In my macro, I need to, from any column, move the active cell to column A, while remaining in the same row.

View 2 Replies View Related

Locate The Last Active Cell In A Column

Dec 2, 2008

Is there a formula I can use to locate the last active cell in a column. I did use the count function, however this isn't always reliable if there are blank cells within the column

View 5 Replies View Related

Find Name Of Column Active Cell Is In

Jul 7, 2006

I have a code which looks at sheet2, useing a date value, and returns the Vent value and the Tanker value to sheet1. Because of the file size I have pasted a small section of Sheet2 in the hopes you can see what I am doing. As can be seen my code is not going to work with Offset as soon as the Data fills further down the sheet(every 2 weeks). I need a way to reference the active cells column name (it is a named range) or header name. Both are the same. That is the header name is the same as the name of the range. there is a way to perhaps find the first cell of the column,which I guess would work,but have reached a stale mate with what I've tried so far.

Vent 01Vent 02Vent 03Vent 04
Date3/06/063/06/06n1/06/06
Tanker8248824617606
WhoJ AshJ AshEmptyHarry
Date
Tanker
Who

Private Sub DueCommandButton_Click()
Dim strRecordID As Range
Dim rngData As Range
Dim Vents2 As Range, Tanker_Result As Range
Dim wsheet1 As Worksheet, wsheet2 As Worksheet
Dim Column_Name As Range
Dim ActiveCell As Range
Set wsheet1 = Worksheets("Sheet1")
Set wsheet2 = Worksheets("Sheet2")....................

View 2 Replies View Related

Use Active Cell Row To Check Another Column

Dec 22, 2006

I've been racking my brains trying to figure this out but cant, please can someone assist. I need to write some vba code that looks at cells in column aa and ag (on the same row) and displays a message is ag > 0 and aa <> "Agency".

View 8 Replies View Related

Sort By Active Cell Column

Jan 7, 2007

I am trying to perform a sort based on the ActiveCell.Column

I thought my code would exclude the hearer rows, but presently it moves the header rows beneath the data

I tried
Header:=xlGuess as well as
Header:=xlNo

Same result

What am I doing wrong?
Thanks
-marc

Private Sub comp_mySort()

Selection.Sort Key1:= Cells(1, ActiveCell.Column), _
Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

End Sub

View 9 Replies View Related

Set Variable To Row & Active Cell Column

Jan 8, 2007

I have a sort procedure I have been working on. Sort By Active Cell Column
Now I would like to make sure the row of the activecell.column is row 7. I tried

Private Sub comp_myMonthlyReport_SortAscend()
Dim rng As Range
With ActiveWindow
rng = .ActiveCell(7, .ActiveCell.Column)
End With
Selection.Sort Key1:=rng, _
Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

But I receive this error: Run-time error '91': Object variable or With block variable not set

View 6 Replies View Related

Excel 2010 :: Highlight Active Row - Change Default Border And Fill?

Jan 13, 2013

Using Excel 2010. Is it possible to change the default line thickness and fill color when selecting the ActiveSheet Target Row below?

I would like a thin border and a light grey fill - without interfering with any fomatting or conditional formatting that has been applied to the worksheet.

View 1 Replies View Related

Highlight Row And Column On Move Down Of Cell

Jun 18, 2009

As I move down a cell, I would like the entire row and column be highlighted. Is that possible?

View 11 Replies View Related







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