•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