View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How to make the active cell "pop out"

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