Conditonal Formatting

G

geza

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.
 
F

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

geza said:
Hi Everyone!

I am trying to find a formula (if there is one) to accomplish the
Click to expand...
following task in a worksheet containing several thousand rows:
Setting the height for the rows in the document depending on the
Click to expand...
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.
 
J

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.
Click to expand...
Doesn't 'wrap text' in Format > Cells > Alignment achieve more or less
what you need?
 
Top