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.
Formatting a column with repititive lines of texts with same col