Formatting a column with repititive lines of texts with same col [Closed]

Registration date
Thursday October 30, 2014
Last seen
October 30, 2014

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!