What formula should I use to copy the value and format of reference cell.
Example in A1=”World” (in blue) What should I type in C1 to copy the value and color?
thanks.