This article explains how to set up cell colours and styles before entering an ipullDisplay function.
ipullDisplay only pulls back a page's values, not its colours and styles. The quickest way to set up the styles is to do a manual pull into the range before entering the ipullDisplay.
1 Enter your ipull function
2 Name the Pulling Range
Giving your pulling range a name helps you to easily select it again. To do this, select the range of cells you want to pull into, then enter a name into the name box in the top left:
Whenever you need to highlight this range again, just select the name from the name box dropdown and all the cells in the range will be selected.
3 Manually Pull the Styles and Formats
With the target range highlighted, choose Pull from the ipushpull ribbon:
Choose the page you are pulling from:
And press the Pull button. This will pull a snapshot of the page into your range, with all its formats, colours, column widths etc.:
4 Enter the ipullDisplay
Finally, with the entire range still selected, enter your ipullDisplay function (as described here) and hit CTRL+SHIFT+ENTER:
The styles and formats will be left unchanged, but the values will now update live.