Forum Discussion
Taryn Mancine
Jul 06, 2017Copper Contributor
Conditional Formatting Help
I am working on a large spreadsheet for a project and would like to show a gradient fill bar (estimate percent complete) in the fully completed column (W). As items in the row are completed wi...
SergeiBaklan
Jul 06, 2017Diamond Contributor
Hi Taryn,
You may calculate number of unfilled cells in the row by COUNTA() in W or in helper column, and based on it apply Data Bar conditional formatting to W changing default settings in the rule for Minimum and Maximum on numbers (let say min = 0 and max is the number of cells in the row to be filled).