Help required for Conditional Text Coloring

[#1]

Hi,

I have data like following table:

Employee	Class	Flag
A	111	N
A	121	Y
A	131	N
B	211	Y
B	212	N
C	311	N

But i want single row for every employee. So I have used Concat and I have table like below:

Employee	Class	Flag
A	111/121/131	N/Y/N
B	211/212	Y/N
C	311	N

But I want to display class with flag 'Y' in red color, rest of with black.

Employee	Class	Flag
A	111/121/131	N/Y/N
B	211/212	Y/N
C	311	N

How to achieve this?

Thanx in Advance..!!