Glad to help on the conditional formatting.

Hopefully someone can help you with the second part of your question.