Any way to keep the formatting when using a formula in Excel2007
Closed
Sven60
Posts
1
Registration date
Thursday October 16, 2014
Status
Member
Last seen
October 16, 2014
-
Oct 16, 2014 at 07:32 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 20, 2014 at 11:07 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 20, 2014 at 11:07 AM
Related:
- Any way to keep the formatting when using a formula in Excel2007
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- How to transfer data from one sheet to another in excel using formula - Guide
- Number to words in excel formula - Guide
- Excel formula to change cell color without conditional formatting - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Oct 20, 2014 at 11:07 AM
Oct 20, 2014 at 11:07 AM
Hi Sven,
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.
Best regards,
Trowa
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.
Best regards,
Trowa