Any way to keep the formatting when using a formula in Excel2007
Closed
Sven60
TrowaD
- Posts
- 1
- Registration date
- Thursday October 16, 2014
- Status
- Member
- Last seen
- October 16, 2014
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Any way to keep the formatting when using a formula in Excel2007
- How to change date format in excel using formula - Guide
- Excel conditional formatting 3 color scale formula ✓ - Forum - Excel
- Excel conditional formatting 4 color scale formula ✓ - Forum - Excel
- Conditional formatting blank cells with formula - Forum - Office Software
- Describe the basic formatting of html documents layout. - Articles
1 reply
TrowaD
Oct 20, 2014 at 11:07 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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