Hi all,
I have two named ranges on Worksheet1 (e.g. "RANGE1" and "RANGE2").
These ranges have cell formatting (some bold font, some bordered, some fill colors to distinguish rows).
Also on Worksheet1, I have a dropdown in cell A2 that references those ranges; we'll say "First Range" and "Second Range"
On Worksheet2 within the workbook, I have the following formula in cell A1:
"=IF(Worksheet1!A2="First Range",RANGE1,RANGE2)"
This formula properly populates and cascades (right and down) the contents of the cells in the chosen range from the dropdown.
The problem is, that population does not come with the formatting in the chosen range.
Is it possible to have a range's individual cell formatting populate from Worksheet1 to Worksheet2 with the chosen range's cell contents?
I have two named ranges on Worksheet1 (e.g. "RANGE1" and "RANGE2").
These ranges have cell formatting (some bold font, some bordered, some fill colors to distinguish rows).
Also on Worksheet1, I have a dropdown in cell A2 that references those ranges; we'll say "First Range" and "Second Range"
On Worksheet2 within the workbook, I have the following formula in cell A1:
"=IF(Worksheet1!A2="First Range",RANGE1,RANGE2)"
This formula properly populates and cascades (right and down) the contents of the cells in the chosen range from the dropdown.
The problem is, that population does not come with the formatting in the chosen range.
Is it possible to have a range's individual cell formatting populate from Worksheet1 to Worksheet2 with the chosen range's cell contents?