Many thanks Anne. That worked as planned.

Robin

On Sun, 25 Mar 2007 00:56:32 -0400, "Anne Troy"
wrote:

Why do you need VBA? Why don't you instead use Conditional Formatting?
Format--Conditional Formatting.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Robin Chapple" wrote in message
.. .
I have a worksheet that records attendance with code that enters
"Present" when double clicked.

Can I have VBA code to format the pattern to a colour?

Thanks for your help,

Robin Chapple