Different colour for each formula result obtain in one cell

Closed
OM - Jan 22, 2015 at 09:25 AM
Hello,


In Excel , I want different format for formula result in one cell.

A1=0 & A2 = THANKYOU

=if(A1=0,"OK","NOT OK")&RIGHT(A2,5) ----- > A3

1ST PART : if(A1=0,"OK","NOT OK") : Colour -yellow i.e.Ok in red in A3

2nd PART : RIGHT(A2,5) : Colour - green.i.e THANK in green in A3

A3 : Ok Thank