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 with different text (dates, Yes/No, initials, etc.), the bar will gradually fill. I am sure I need a forumula, but I am not sure where to start. I have attached an example chart to better understand.
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).
