Highlighting every next rows after a row containing specific text and splitting rows

Dear Experts

I need help on an excel file (attached) containing MCQs. I want to highlight all the questions in one color and all the explanation for each question in another color. I want to also break the Multiple choices in rows instead of keeping them in one row.

Any help to solve this challenge would be highly appreciated.

Khalid

Use CF formulae like:

=LEFT(A1,11)="Explanation"

and

=LEFT(A1,10)="Question #"

and apply to $A$2:$A$860

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.