Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Macro for 3-color scale condition formatting


I would like to format a column with a 3-color scale condition. I need to do it programmably, because the range changes when I insert new cell values (in other words, I don't want the conditional formatting to affect the same range, but find a way to manage the "gaps" by updating the range). Could someone help me?

PS I already have a good knowledge in VBA coding with Excel, but not really in any language with LibreOffice (on Linux).

Many thanks in advance!