Conditonal Formatting

[Guest]

Hi Everyone!

I am trying to find a formula (if there is one) to accomplish the following task in a worksheet containing several thousand rows:

Setting the height for the rows in the document depending on the number of lines in a particular row, i.e the height of all rows that have “one line†should be 20, the ones with 2 lines should be 25 or 30, etc., instead of manually selecting every single row and then setting the row height.

Thanks.

 

[Frank Kabel]

Hi
this is not possible with a formula but this would require VBA (a
macro) Is this a feasible way for you?

--
Regards
Frank Kabel
Frankfurt, Germany

Hi Everyone!

I am trying to find a formula (if there is one) to accomplish the

following task in a worksheet containing several thousand rows:

Setting the height for the rows in the document depending on the

number of lines in a particular row, i.e the height of all rows that
have “one line†should be 20, the ones with 2 lines should be 25 or 30,
etc., instead of manually selecting every single row and then setting
the row height.

 

[John Woodgate]

I read in microsoft.public.excel.misc that Frank Kabel

Hi
this is not possible with a formula but this would require VBA (a
macro) Is this a feasible way for you?

--
Regards
Frank Kabel
Frankfurt, Germany


following task in a worksheet containing several thousand rows:
number of lines in a particular row, i.e the height of all rows that
have “one line†should be 20, the ones with 2 lines should be 25 or 30,
etc., instead of manually selecting every single row and then setting
the row height.

Doesn't 'wrap text' in Format > Cells > Alignment achieve more or less
what you need?

 

[Guest]

Yes, a macro would be fine. Thanks again. Geza.