> For the complete documentation index, see [llms.txt](https://interopxyz.gitbook.io/excel-plus/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://interopxyz.gitbook.io/excel-plus/components/analysis/conditional-top.md).

# Conditional Top

Applies top percent based conditional formatting to a Range

## Description

Applies top percent based conditional formatting to a Range

{% tabs %}
{% tab title="Preview" %}
![](https://2501927618-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe08Uu2w6ybaOmfvcxkKf%2Fuploads%2F73yooj4xJFRd2B7im0cq%2FAnalysis_Con_Top.png?alt=media\&token=4396416a-482c-43f6-a4e9-2214190017d7)
{% endtab %}

{% tab title="Location" %}
**Name** | Conditional Top

**Nickname** | Con Top

**Tab** | ExcelPlus

**Panel** | Analysis

**Division** | 2
{% endtab %}

{% tab title="Inputs" %}
**Obj** | **Object** (*object*) | A Range, Worksheet, or Workbook Object

**T** | **Total** (*int*) | The total number of values to highlight

**F** | **Flip** (*bool*) | If true, the bottom values will be highlighted

**C** | **Cell Color** (*color*) | The cell highlight color
{% endtab %}

{% tab title="Outputs" %}
**Obj** | **Object** (*object*) | A Cell, Range, Worksheet, or Workbook Object
{% endtab %}

{% tab title="Mode" %}
*none*
{% endtab %}
{% endtabs %}

## Usage