[DRS]

Would like to run a macro that would look at a row of
cells and if anything existed in it, then underline a
different row.

IF B3 CONTAINS "ANYTHING" THEN UNDERLINE A3

And do the above for the whole row or a set number.

I know I have read this here before but cannot find an
example.

Thanks,

Dave

[Richard Choate]

Check out FORMATCONDITIONAL FORMATTING
Richard Choate

"DRS" wrote in message
...
Would like to run a macro that would look at a row of
cells and if anything existed in it, then underline a
different row.

IF B3 CONTAINS "ANYTHING" THEN UNDERLINE A3

And do the above for the whole row or a set number.

I know I have read this here before but cannot find an
example.

Thanks,

Dave

[Bob Phillips[_5_]]

You can do this with conditional formatting

In A3, set CF and use FormulaIs with a formula of =IF LEN(B3)0, and
select format and choose underline.

--

HTH

Bob Phillips

"DRS" wrote in message
...
Would like to run a macro that would look at a row of
cells and if anything existed in it, then underline a
different row.

IF B3 CONTAINS "ANYTHING" THEN UNDERLINE A3

And do the above for the whole row or a set number.

I know I have read this here before but cannot find an
example.

Thanks,

Dave