On Jul 14, 9:16*pm, magmike wrote:
On Jul 14, 8:31*am, Don Guillett wrote:





On Jul 12, 8:33*pm, magmike wrote:

In Excel 2007, on WinXP SP3,

I would like to be able to change the format of the currently active
cell to make it more easily visible at a quick glance. Currently, the
active cell is just outlined in a thick black line. Is there a way to
change conditional formatting to change the fill color and/or the
outline color of the currently selective/active cell?

Thanks in advance,

magmike

Right click sheet tabview codeinsert this. Now,when you select a
cell it will hilite it. Does NOT change other formatting.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
* * Cells.FormatConditions.Delete
* * 'With Target.EntireRow
* * 'With Cells(Target.Row, 1).Resize(, 2)
* * With Target
* * * .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
* * * .FormatConditions(1).Interior.ColorIndex = 6 * * *'35
* * End With
End Sub

Supercool, and easy!
How would you modify this to change the selections text color if it is
white, to black (but only for the selection period)?- Hide quoted text -

- Show quoted text -

I am having problems with my Conditional formatting. I have quite a
few rules that change an entire row's fill color and sometimes text
formatting based on the text in a certain column. When I use this code
in a sheet where this conditional formatting is present, when I make
my first selection, all of the conditional formatting changes
instantly disappear.

Any ideas?