Different Colors for Progress Bars in Google Sheets

In this how to, Lean Strategies International LLC will show you how to change the color of your progress bar in #googlesheets using a countif formula and a sparkline formula. As a reminder google sheets is part of the google #workspace platform.

The Formula shown in this video is:

=sparkline(COUNTIF(C3:E3,"TRUE"),{"charttype","bar";"color1","#da1313";"max",3})

** Note: you will need to select the appropriate cells where "C2:E3" is. Also, when entering your color code (example: #da1313) you will need to select or enter the appropriate color code.

[HasanJaffrey]

This is helpful, thank you!

Is there a way to add % to the progress bar?

[alex_ya_boi]

but how do you change the individual step colors? (step 1=red, step 2=orange, step3=green)