Skip to content

excel conditionalformatting

Jump to bottom
zmworm edited this page Apr 29, 2026 · 51 revisions

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.64

Clone this wiki locally