Format same as range cell
Posted on 2013-01-03
I wish to conditionally format Cells in row A to recognize the cell that matches it in the range of cells in row D and then format it the same as that matching cell in the range in row D.
i.e. A1 would be in bold if D1 were in bold. i.e. A1 would be yellow if D3 were yellow and so on A3 would stay the same as there is no match for it in the list in row D or if there is a match the formatting is the same as the original.
I would like it to only recognize cell color, font color and if the font is bold or not. but this is not necessary.
A B C D
1 L3x3x1/4 L3x3x1/4
2 L6x6x1/4 L4X4X1/4
3 L7x7x1/2 L6X6X1/4