Appreciate any help!

I have a date table with a series of column inputs beside it..
ie For the date 5th Nov 2009 entered in cell b2, i have 3 cells c2, d2, e2 which may or may-not have an entry ie either nthg or say "L"

I want to display in f2 the text inputs from c2-d2-e2 if they have say the value"L", but wish to differentiate these results by colour

ie if the relevent cells have a value i want to differentiate and display these in f2 as...c2 in Red, d2 in blue, e2 in green.

if any of the c2, d2, e2 values are blank i want to exclude them

how can i achieve this without any VBA?

Thx in advance