I have a Macro that takes Data entered on a “Data Input” type of Spreadsheeet (1) and copies/transfers the data as well as insert a new row for data to be placed to another spreadsheet (2). Some of the fields are formatted in such a way that if the data is outside a certain range the data which is a number goes red. However when i try to transfer the data to Spreadsheet (2) the red formatting disappears and is replaced with automatic. PLEASE HELP!
