Fairly technical question -- hope someone can help:
Let's say I have a formula in cell A1: "=IF(condition,B4,B5)". Normally, the *value* of either cell B4 or B5 would appear in target cell A1. Let's assume B4 and B5 have different formatting. Is there any way to copy the formating of the cell along with the content?
In reality, the result of my formula can be about a dozen different cells -- not just two -- each with a distinct color background. For that reason, Excel's "conditional formatting" is not working for me. Conditional Formatting only allows me to choose up to three different formats for the cell.
Can anyone help? Thanks!
Brian Bale
Let's say I have a formula in cell A1: "=IF(condition,B4,B5)". Normally, the *value* of either cell B4 or B5 would appear in target cell A1. Let's assume B4 and B5 have different formatting. Is there any way to copy the formating of the cell along with the content?
In reality, the result of my formula can be about a dozen different cells -- not just two -- each with a distinct color background. For that reason, Excel's "conditional formatting" is not working for me. Conditional Formatting only allows me to choose up to three different formats for the cell.
Can anyone help? Thanks!
Brian Bale