Active Cell
 

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 typ
Cells.Interior.Color = byWhit
ActiveCell.Interior.Color = vbYello
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

Active Cell
 

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

Active Cell
 

Oops

I think you like the Add-in from Chip Pearson
http://cpearson.com/excel/RowLiner.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Ron de Bruin" wrote in message ...
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

Active Cell
 

Thanks! Works beautifully

Howard