Format a cell IF...
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
|