excel conditionalformatting

Excel: Conditional Formatting

Conditional formatting rules for dynamic cell styling.

Path: /{SheetName}/cf[N]

Operations

• add - Add data bars, color scales, icon sets, and formula-based rules

get

officecli get data.xlsx /Sheet1/cf[1]
officecli get data.xlsx /Sheet1/cf[2]

set

Property	Accepted Values	Description
color	hex RGB	Update data bar color
minColor / midColor / maxColor	hex RGB	Update color scale colors
iconSet	icon set name	Update icon set
formula	formula string	Update formula condition
fill	hex RGB	Update fill color
font.color	hex RGB	Update font color

officecli set data.xlsx /Sheet1/cf[1] --prop color=FF6600
officecli set data.xlsx /Sheet1/cf[2] --prop minColor=FFFFFF --prop maxColor=FF0000

remove

officecli remove data.xlsx /Sheet1/cf[1]

---

Based on OfficeCLI v1.0.28