I am trying to create a sparkline formula in Google Sheets for a horizontal bar with negative numbers, for a project budget tracker.

The idea is that the horizontal bar is centered in a cell, so it can go right (green color) for positive numbers, and left (red color) for negative numbers, while keeping yellow color for inbetween. Maximum and minimum should be for each cell different, based on the approved budget for that line, so I would prefer a formula which I can drag for the other cells.

In the provided document you can see my attempt for the formula.

Remark: I use European delimiters, so for more complex formulas it can get confusing where to put “;” or “”, for the level of knowledge I currently possess.

Thank you in advance for the help!