Keeping cell colour

[rynhardt]

Good day,i hope my issue is an easy one to solve, i am totally stuck so here i go.I have a series of values in Column A Hello 1Hello 2 Hello 3Hello 4 (with hello written in black and the numbers are written in red) and in block G2 i have the formula:=CHOOSE(RANDBETWEEN(1,4),A1,A2,A3,A4) but the info that is then displayed in G2 is in all black how do i fix my formula to display it as on Column A with the text black and numbers in red?

 

[Special-K99]

Formulas can only work on cell values not the cell's formatting.

How did you get the values in column A to have two colours in the first place?
Presumably you selected part of the cell text and formatted that text from the ribbon

Just use the same method on cell G2.