1 min readfrom 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.

submitted by /u/juupmelech626
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article