AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() If D4=no, E4=no, F4=yes, G4=yes, H4=yes then I4 would equal 60% or light yellow fill. If D4=no, E4=yes, F4=yes, G4=yes, H4=yes then I4 would equal 80% or light green fill. If D4:H4=yes then I4 would =100% or be formatted green fill 0%- 100% or red/green/yellow fill etc.) based on the presence of the "yes" value I want the "total"/"net progress" cell in "Column I" to automatically show the progress (i.e. Indicate its progress towards completion (i.e. ![]() There are five individual tasks (Columns D-H) and each is given a text value to Hello! I am building out a worksheet and I needed assistance to develop a formula to conditionally formatting a "net progress" or "data bar" cell to track project completion.
0 Comments
Read More
Leave a Reply. |