Hi!

This will return a rows height**:

Create this named formula:
Goto InsertNameDefine
Name: RowHeight
Refers to: =GET.CELL(17,INDIRECT("A1"))
OK

Formula to get the row height of row 1 (that's what the reference to A1
means in the above formula. It will ALWAYS point to cell A1)

=RowHeight

** Simply hidding a row/column does not trigger a calculation so the formula
will not update until you either manually calculate or an automatic
calculation is triggered by some other event. However, applying a filter
that hides rows DOES trigger a calculation. Both hidden and filtered rows
will return a row height of zero.

Biff

"Joseph in Atlanta" <Joseph in wrote in
message ...
I am looking for an Excel function that will return info about whether a
row
is hidden or not... returning the height may work too, if height value
goes to
0 or low value when the row is hidden.

I am wanting to change a formula in Excel, depending on whether a cell/row
is
hidden or not. There IS a function =CELL("format",E20) that will give the
formatting of a dell's data, or =CELL("width",B12) that will show width;
but
I can NOTfind something similar to =CELL("width",G47)

One of my intended uses:
Conditional formatting, to set highlight color of every other line of a
report:
I can set up conditional formatting with =EVEN(ROW(F14)) that works FINE
to
allow formatting to highlight every other row, adjusting properly when new
rows
are added in the middle of a table... BUT when you use a FILTER on the
data
rows
and some of them are hidden, it looks bad, when the DISPLAYED rows have
scattered background coloring. Instead of using ROW(F14), I'm wanting to
calculate my own value for "displayed row" with something like this:
=IF(CELL("height",G22)3, G21+1, G21) which would increment the displayed
row counter ONLY if the height of G22 was more than 3 pixels.

OK, that's enough detail for now- I think you get the idea.

Perhaps there