I want to know if it is possible to format text within a formular?

Using the =REPT("I",cell) formular - ( from Juice
Analytics)
you can effectively draw a small bar chart in a sigle cell.

What I want to do is combine three cells to a single bar, but have each
cell value formatted as a different colour, within the single.

so formular currently is,

=(REPT("|",cell 1))&(REPT("|",cell 2))&(REPT("|",cell 2))

What I want to do is (but obviously the below does not work - is there
a format to do this?)

=([Red]REPT("|",cell 1))&([Blue]REPT("|",cell
2))&([Green]REPT("|",cell 2))