- Registration date
- Sunday September 12, 2010
- Last seen
- January 18, 2021
Sorry to inform you that formula's are not capable of transferring format.
If you used conditional format to colour column A then you can do the same for column B, otherwise VBA would be the only solution for you.