Don't think possible but right click sheet tabview codeinsert thisSAVE
If you want to keep the highlighting for past selections delete the cells
line
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = 0
Target.Interior.ColorIndex = 6
End Sub
--
Don Guillett
SalesAid Software
"Carroll" wrote in message
oups.com...
Hello,
Is there a function I could use with Conditional Formatting that would
allow me to color a cell if it was the active cell? I know I could
probably do this in VBA, but I would be interested in a method that
used Condtional Formatting.
Thanks,
Carroll Rinehart