Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
"outline active cell differently than other cells" | Excel Discussion (Misc queries) | |||
how do I make "Add-in" in Excel tools menu active? Its grey now | Excel Discussion (Misc queries) | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) |