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