Formating and Reference

[chintan_1985]

Can anyone hlep me out?


I have some data in the column A and need to refer3nce it to column B by someformula with the destination formating.


A1 B1


12 12


The value in the A1 is formated as Red Bold Font and want to carry the same formating with the value to B1.

 

[vasim]

A simple Copy Paste should work


(CTRL C CTRL V)


or you might want to have a look at Paste Special -values then formats

(ALT E S V) then

(ALT E S T)

 

[chintan_1985]

Hi,


I am in serch of a formula that can directly derived the source formatting.


Thanks for the reply.