LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joseph in Atlanta
 
Posts: n/a
Default Is there a function to show if cell/row(X:Y) is hidden? or width?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Monty Excel Worksheet Functions 2 January 30th 06 01:37 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM
#VALUE in cell but pop up function box show right number Ted Dalton Excel Discussion (Misc queries) 1 December 14th 04 03:15 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"