Forum Discussion
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...
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).