Brilliant!!

--
Cheers
Nigel



"Tushar Mehta" wrote in message
om...
No, you don't have to do one cell at a time. Select all cells and set
the conditional formatting formula to use a relative address as in
=ISNA(A1) rather than $A$1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , nigel-
says...
You guessed it right!

I had be playing around with conditinal formatting - your tip makes it
work.
Pity I need to set each cell in the range one by one?

Thanks again