Hi all,
I am trying to use conditional formatting / VBA / whatever it may be, to match the destination output formatting with the source formatting. My lists of data vary in length and formatting. When I input a value into X1 my lists of data appear but I want the formatting to move with the lists. I've attached two screenshots. The first one is what is currently happening, the second it what I want to happen. Is there anyway to do this?
I am trying to use conditional formatting / VBA / whatever it may be, to match the destination output formatting with the source formatting. My lists of data vary in length and formatting. When I input a value into X1 my lists of data appear but I want the formatting to move with the lists. I've attached two screenshots. The first one is what is currently happening, the second it what I want to happen. Is there anyway to do this?
