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