Change colours of various text

Ralph - Mar 24, 2016 at 02:00 AM

I have a spread sheet with numerous rows named 1, numerous 2, then 3 etc. I want to change the text colour each time the text changes in each row. ie all the 1's cyan, then 2's blue, then 3's cyan, 4's blue and so on. How do I go about this.

Thankyou in advance