Hightlighting Excel Rows and Columns for Presentation 1

[misscrf]

I have a series of excel spreadsheets. As one person is talking, I need to hightlight the cell or row that they are talking about. I am looking for a clean way to do this. I am not sure if using the paint can is the best method (and then undoing.)

Is there anyway to change the color that the row/column becomes when it is just selected? It is kind of purple/translucent. Can we change that to a yellow?

Thanks for any suggestions!

:thanx:

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[SkipVought]

Hi,

You could try Conditional Formatting, by entering a value to the left or right of your presentation area. The FONT COLOR could be WHITE to minimize attention.


Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[misscrf]

I'm not sure I understand you.

I will have to be able to highlight a row or column on the fly. I will not know what to highlight until the person is speaking and saying what I should highlight. The spreadsheet will be visible on a screen, so if you mean highlight something, go to conditional formatting, etc.
I can't do that. I need something that will be less visible as to how I am highlighting, but just hightlight as I click on a cell, row, column.

To make what I am selecting show up better.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[xlbo]

Skip is suggesting that you enter a simple character into a cell on the line you want highlighting - the conditional formatting would be looking for the existence of this character and if entered, would highlight the row

Other than that, this really needs VBA....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AnotherHiggins]

The easiest way I can think of is with VBA. You could insert something like the following into the Worksheet object (not a module).

Private Sub Worksheet_BeforeDoubleClick(ByVal _
    Target As Range, Cancel As Boolean)
Cancel = True
Cells.Interior.ColorIndex = xlNone
ActiveCell.EntireRow.Interior.ColorIndex = 6
End Sub

Private Sub Worksheet_Deactivate()
Cells.Interior.ColorIndex = xlNone
End Sub

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[Zathras]

If you grok VBA, you could use code like this:

Dim LastColorIndex As Long
Dim LastRow As Long

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   If LastRow > 0 Then
     ActiveSheet.Rows(LastRow).Interior.ColorIndex = LastColorIndex
   End If
   LastColorIndex = Target.Interior.ColorIndex
   LastRow = Target.Row
   Target.EntireRow.Interior.ColorIndex = 6
End Sub

For further help with VBA, post in forum707.

 

[xlbo]

nice john - I'd use Target rather than ActiveCell though... Generally doesn't matter but it is possible to get discrepencies otherwise

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AnotherHiggins]

Thanks for the tip. 'Still learning, ya know.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[xlbo]

As a general point 'Target' in any event will point to the cell that the event is firing from so:

[tt]
Event Refers To
Selection Change Selected cell
Change Changed Cell
Before Double Click Double Clicked Cell
Before Right Click Right Clicked Cell
[/tt]

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[misscrf]

thanks all. I have tried some code, and here is what I have:

Sub Highlight()

Cells.Interior.Color = vbWhite
Selection.Interior.Color = vbYellow

End Sub

Sub NoHighlight()

Cells.Interior.Color = vbWhite
Selection.Interior.Color = vbWhite
ActiveWindow.GridlineColor = vbBlack

End Sub


problem is that the higlight (and no hightlight) takes away my gridlines. I need to keep those. I tried in the no highlight, to set my gridlines, but it sets the diagonal line too.

Any thoughts on that?

Thanks!

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[SkipVought]

    Cells.Interior.ColorIndex = xlNone
    Selection.Interior.Color = vbYellow

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[misscrf]

Thanks, that did it.

misscrf

It is never too late to become what you could have been ~ George Eliot