> 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-percent.md).

# Conditional Percent

## Description

Applies top percent based conditional formatting to a Range

{% tabs %}
{% tab title="Preview" %}
![](/files/mMdA0dlTefC0cUqyucam)
{% endtab %}

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

**Nickname** | Con Per

**Tab** | ExcelPlus

**Panel** | Analysis

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

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

**F** | **Flip** (*bool*) | If true, bottom percent 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