Why not use conditional formatting?

Highlight A3:G3 and select Format - Conditional Format
Formula Is =$K3=1

And now add the desired format...
--
HTH...

Jim Thomlinson


"mattgoof2005" wrote:

In excel 2003, how can I program the following into a macro:

if K3=1 then highlight A3:G3