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
Related:
Any way to keep the formatting when using a formula in Excel2007
