Forum Discussion
bharker
Aug 01, 2020Copper Contributor
Need assistance with formulas
Hello all, I needed some assistance with some formulas. Looking for column B starting @ B5 to auto populate with a yes or no depending on the answers in columns D thru I. If they are all yes, then B...
- Aug 01, 2020I'm not sure because the translation is not the best ... but here is an example.
Have a dro down menu built in D, at the same time the formula is built in B.If you find this helpful, please mark it as Like (click thumbs up) and as "Best Answer", it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
bharker
Aug 01, 2020Copper Contributor
Wholly cow! Exactly what I was looking for. I really like the 100+ days vacant highlight.
RonR
Aug 01, 2020Copper Contributor
bharker Glad you liked it!
I've reattached the file. I forget that filling with formats also replicates (and messes up) cell borders.
I corrected the border formats, but you probably already caught my screw up. ~RonR
- bharkerAug 01, 2020Copper ContributorI didn't catch that at all. Thanks for updating. Much appreciated!