I want to be able to copy the returned results of a conditional formula that changes colour to another location but without the conditional formatting
ie if the results of column Trans(Z4:Z1000) have conditional formatting altering each cell based upon a rule to different colours I want the colours and values in those cells copied to Sheet8(D2:D998) and have none of the conditional formatting.
The reason is that if the parameters that the conditional formatting uses changed then the colours would alter and I need to keep history.
Any Ideas it seems simple and I'm sure I'm just missing something here????