View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default


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