Highlighting using a macro
 

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

if K3=1 then highlight A3:G3

Highlighting using a macro
 

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

Highlighting using a macro
 

Thanks

"Jim Thomlinson" wrote:

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

Highlighting using a macro
 

How can I assign priorities to these conditions?(If K3=1, the item in row 3
is scheduled to be complete, but if G3=A, the item has been completed and
doesn't need to be highlighted.)

"mattgoof2005" wrote:

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

if K3=1 then highlight A3:G3

Highlighting using a macro
 

You can add up to 3 conditional formats. The conditions are a heirarchy with
condition 1 superceding 2 and 2 superceding 3. So condition 1 should evaluate
the value of Cell G3 and condition 2 should evaluate the value of K3...
--
HTH...

Jim Thomlinson


"mattgoof2005" wrote:

How can I assign priorities to these conditions?(If K3=1, the item in row 3
is scheduled to be complete, but if G3=A, the item has been completed and
doesn't need to be highlighted.)

"mattgoof2005" wrote:

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

if K3=1 then highlight A3:G3