Any way to keep the formatting when using a formula in Excel2007

I would like to copy the contents and format of a column of cells and paste them in another column using a formula.

All columns are formatted as type = General
Column A is a list of random IP addresses that are color formatted as green or red cells.
Column C is also a list of IP addresses (a master list)

In column B, I want to take all the IP addresses in column A and line them up on the same row as the IP address in column C (and keep the color formatting from column A).

In column B to get the IP address from column A to line up with the IP addresses in column C, I used the formula:
=IF(ISNA(MATCH(C1,A:A,0)),"",INDEX(A:A,MATCH(C1,A:A,0)))

This works but column B does not have the color formatting as column A

Is there any way to keep the formatting when using a formula?

Thank You
Sven