⚫Conditional Top

Applies top percent based conditional formatting to a Range

Description

Applies top percent based conditional formatting to a Range

Preview

Location

Name | Conditional Top

Nickname | Con Top

Tab | ExcelPlus

Panel | Analysis

Division | 2

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

Outputs

Obj | Object (object) | A Cell, Range, Worksheet, or Workbook Object

Mode

none

Usage