Returning row values based on conditional formatting variables
- by Mike Bodes
I'm not entirely sure how to properly explain this, but here we go...
I'm trying to create a single budgeting document that allows me to manage purchasing and reconciliation for multiple projects. I would like to create separate sheets per project and have purchased items populate on a master sheet.
Using conditional formatting, I've set one of…