Formatting a column with repititive lines of texts with same col

skyK Posts 1 Registration date Thursday October 30, 2014 Status Member Last seen October 30, 2014 - Oct 30, 2014 at 05:19 AM

i have just completed a time and motion excercise and i have enetered the details into excel.

i have also cleaned up my data, checked for inconsistencies and now i want to continue analysing the sheets.

the problem now is formatting the texts in a column with different colours ( some of these texts are repititive because they are gathered from more than one person)
e.g if admin work is yellow for person a on the same worksheet, i want it to apply to all admin work on this same worksheet .

thanks i hope someone can help me.