Referencing cell content and formatting

[Beans]

Hi, in one work sheet I have a value say G in cell A1, with the cell
pattern coloured blue. On a second sheet I want to reference A1 again in say
cell B22. I do this with = Sheet1!A1. The value G comes over but the
background colour does not.

Any way to have the second sheet cell B22 inherit the formatting of the
first sheet cell (A1)

Thanks

 

[JLGWhiz]

Not with a formula. It only brings over the value, not formats. You could
put in a conditional format in that cell so that if it equals G then format
color is Blue.