Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |