Check out this webpage
http://www.mcgimpsey.com/excel/highl...iteRetainColor
I think you like the Add-in from Chip Pearson
http://www.mcgimpsey.com/excel/highl...iteRetainColor
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Howard" wrote in message ...
I want the active cell to be yellow and all other cells to be white. So, In the visual basic window, I change the object to
Worksheet and the procedure to Selection Change. Then I type
Cells.Interior.Color = byWhite
ActiveCell.Interior.Color = vbYellow
However, that gets rid of the gridlines too.
And I think there is an easier way to to do this using conditional formatting and the Countif function(?), but I don't know
how.
Appreciate your suggestions.
HF