Active Cell

[Guest]

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

 

[Ron de Bruin]

Check out this webpage
http://www.mcgimpsey.com/excel/highlightrow.html#HiLiteRetainColor

I think you like the Add-in from Chip Pearson
http://www.mcgimpsey.com/excel/highlightrow.html#HiLiteRetainColor

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

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

 

[Ron de Bruin]

Oops

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

 

[Guest]

Thanks! Works beautifully

Howard