Windows Forum

Ask something
Discussion Locked

Ms Excel Databases

0 helpful
2 replies

by niveadavis

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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!

2 replies

by choppit

If you're recording the macro, make sure you use paste special with the "all" option. This will ensure that conditional formatting gets copied.

This discussion is closed to new replies.