View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
goneil goneil is offline
external usenet poster
 
Posts: 5
Default test for click in cell

Dear Excel community,

I have put a border around cells A1, A2, A3, A4.

Just by clicking in a cell I would like "just" that cell to go:

A1 to go Red, A2 Green, A3 Amber, A4 Blue.

When I click in a cell set the other 3 cells to blank

Thank you to the bright spark that can figure this out.

Cheers
George