What you are trying to do would best be done using a specific Project Planning package like MS Project or Primavera's Finest Hour etc
You can very roughly replicate what you want in excel but the issue you face is that you need to be able to change fonts and font color within a single cell, which excel cannot do without a macro.