> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/visiblehierarchy.md).

# VISIBLEHIERARCHY

#### Syntax <a href="#syntax.60" id="syntax.60"></a>

**VISIBLEHIERARCHY**(widget)

* *widget* - the hierarchy table widget from which only the visible rows should be returned - ***Value type**: widget reference*

#### Remark

* The function returns the currently visible rows, including the level information in the first column.
* The function is for example helpful if a cell style should be applied on a hierarchy widget, see the example below.

#### Examples

In this example, negative values in a hierarchy should get a red background.

If a direct reference would be used in the formula (#me), the whole hierarchy, including the collapsed rows, would be returned, leading to wrong row positions of the applied cell style.

Therefore VISIBLEHIERARCHY(#me) should be used instead.

<figure><img src="/files/NCSUyJ0fwdrp2Q2ZICwz" alt=""><figcaption></figcaption></figure>