Format a cell IF...

  • Thread starter Thread starter DRS
  • Start date Start date
D

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
 
Check out FORMAT>CONDITIONAL FORMATTING
Richard Choate

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
 
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.
 
Back
Top