•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting to show completion involving multiple cells.
I'm building a progresss sheet that is based on completion of multiple conditionals. The conditionals are e22:e25 and I22:I25, each representing a different requirement. I want to do a tracking bar at the base of the sheet using three formating rules based on the completion date of the reqs.
Rule 1 is =e22:e25,I22:25<Today() Rule 2 is =e22:e25,I22:25>=Today()
These come with specific cell formats and work. I'd like to add a 3rd rule that shows a progess percentage. For example lets say e22, e24, e25 and I23 are all done but the rest remain with no completion date enter it would show a bar 50% filled and the words in progress across the bar.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Conditional Formatting
#completion
#progress sheet
#completion date
#percentage
#formatting rules
#progress percentage
#tracking bar
#requirement
#conditions
#multiple conditionals
#e22:e25
#I22:I25