Hi, I have a spreadsheet which has 5 columns. I want it transposed by project, listing all the names of people working on that project in columns. On top of that I want anyone with an 'L' in column E to be highlighted in green (but only for the associated project) and same for anyone with an 'O' highlighted in blue. Can anyone help?