Not too clear what you want.

Clicking in a cell to make it active will not format A1 unless you used event
code.

Is there something missing from your post?


Gord Dibben MS Excel MVP

On Thu, 10 Apr 2008 10:30:03 -0700, Tufail
wrote:

hi,
i have a range of A1:F1 so what i want now if any active cell in B1:F1 A1
want to be shadad !
Thanks in advance.