Is it possible to make the active cell more noticeable by either
having the active cell be a different color or have a darker border
around it?

I work on Excel spreadsheets on both a Mac and a PC. The PC active
cell is very noticeable but I have a hard time seeing that on the Mac
version. I tried filling in the table with a light background color
to see if the active cell would be a different color. It's not. Any
suggestions on how to make the active cell more noticeable.

I'm working with Microsoft Excell 2004 for Mac
Version 11.3.7
I have a 12" PowerBook G4. (The small screen doesn't help the problem)

Julie

Here is one way

'----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'----------------------------------------------------------------
Cells.FormatConditions.Delete
With Target
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 36
End With

End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Julie27" wrote in message
ps.com...
Is it possible to make the active cell more noticeable by either
having the active cell be a different color or have a darker border
around it?

I work on Excel spreadsheets on both a Mac and a PC. The PC active
cell is very noticeable but I have a hard time seeing that on the Mac
version. I tried filling in the table with a light background color
to see if the active cell would be a different color. It's not. Any
suggestions on how to make the active cell more noticeable.

I'm working with Microsoft Excell 2004 for Mac
Version 11.3.7
I have a 12" PowerBook G4. (The small screen doesn't help the problem)

Julie

Thanks for the code, it works perfect, however when I save anything now it
takes a lot of time to do it. Is that normal behavior because the macro ?
Another question : if I decide to remove it ( the macro ) how can I do it?
Apoligies Julie27 for barging in like this and thanks for the help Bob.

"Bob Phillips" wrote:

Here is one way

'----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'----------------------------------------------------------------
Cells.FormatConditions.Delete
With Target
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 36
End With

End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Julie27" wrote in message
ps.com...
Is it possible to make the active cell more noticeable by either
having the active cell be a different color or have a darker border
around it?

I work on Excel spreadsheets on both a Mac and a PC. The PC active
cell is very noticeable but I have a hard time seeing that on the Mac
version. I tried filling in the table with a light background color
to see if the active cell would be a different color. It's not. Any
suggestions on how to make the active cell more noticeable.

I'm working with Microsoft Excell 2004 for Mac
Version 11.3.7
I have a 12" PowerBook G4. (The small screen doesn't help the problem)

Julie

It should be instantaneous, if it is slow there is something else going on.

To remove it, see http://www.contextures.com/xlfaqMac.html#NoMacros

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"FC" wrote in message
...
Thanks for the code, it works perfect, however when I save anything now it
takes a lot of time to do it. Is that normal behavior because the macro ?
Another question : if I decide to remove it ( the macro ) how can I do it?
Apoligies Julie27 for barging in like this and thanks for the help Bob.

"Bob Phillips" wrote:

Here is one way

'----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'----------------------------------------------------------------
Cells.FormatConditions.Delete
With Target
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 36
End With

End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Julie27" wrote in message
ps.com...
Is it possible to make the active cell more noticeable by either
having the active cell be a different color or have a darker border
around it?

I work on Excel spreadsheets on both a Mac and a PC. The PC active
cell is very noticeable but I have a hard time seeing that on the Mac
version. I tried filling in the table with a light background color
to see if the active cell would be a different color. It's not. Any
suggestions on how to make the active cell more noticeable.

I'm working with Microsoft Excell 2004 for Mac
Version 11.3.7
I have a 12" PowerBook G4. (The small screen doesn't help the problem)

Julie

THANKS for the link.

"Bob Phillips" wrote:

It should be instantaneous, if it is slow there is something else going on.

To remove it, see http://www.contextures.com/xlfaqMac.html#NoMacros

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"FC" wrote in message
...
Thanks for the code, it works perfect, however when I save anything now it
takes a lot of time to do it. Is that normal behavior because the macro ?
Another question : if I decide to remove it ( the macro ) how can I do it?
Apoligies Julie27 for barging in like this and thanks for the help Bob.

"Bob Phillips" wrote:

Here is one way

'----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'----------------------------------------------------------------
Cells.FormatConditions.Delete
With Target
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 36
End With

End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Julie27" wrote in message
ps.com...
Is it possible to make the active cell more noticeable by either
having the active cell be a different color or have a darker border
around it?

I work on Excel spreadsheets on both a Mac and a PC. The PC active
cell is very noticeable but I have a hard time seeing that on the Mac
version. I tried filling in the table with a light background color
to see if the active cell would be a different color. It's not. Any
suggestions on how to make the active cell more noticeable.

I'm working with Microsoft Excell 2004 for Mac
Version 11.3.7
I have a 12" PowerBook G4. (The small screen doesn't help the problem)

Julie

Bob, the code is beautiful. I have no clue what anything in the code
means but it works great. Thanks so much.

Will I need to add this code every time I create a new spreadsheet or
is there a way to have it be included in all future spreadsheets?

FC, no problem butting in. I'm glad others can benefit from my
dilemmas.

Julie