See the help file on colorIndex for more info but basically its

Worksheets("Sheet1").Range("D19").Font.ColorIndex = 3


"Thierry" wrote in message
...
Hello,
With the function concatenate, how can we
A) Ask to get the same format as the original cell
B) Force a color format, like red
Exemple = concatenate(A1; " "; A2; " "; A3)
I would like that
1) A1 displays the same color and number format as the cell A1 (for
example green with number #'##0.00
2) Force the format of A2 in red

I know that the function TEXT exists
=concatenate(TEXT (A1;"#'##0.00"); etc.)
But how can I say "red" or "same format as cell A1" ?
Thank you for all advise