# 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="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-d471538aff2f7136c7cfefb92a248ce9f2424b7e%2Fimage%20(123).png?alt=media" alt=""><figcaption></figcaption></figure>