How to format an icon outside of the cell?

[sovietchild]

Hello, is formatting icons (arrow up +5%, arrow down -5%) only possible inside of the cell? Is it possible to do it inside of an object?

Example attached.

[sovietchild]

One way is to take a picture of the cell under "Developer" but is there any other ways? Developer picture gets pixelated and the borders are gray which can't be changed.

[Andy Pope]

You can use a couple of text boxes linked to 2 cells in order to display a red or green arrow.

If you use a chart object you can conditional display points with custom markers.

[sovietchild]

You can use a couple of text boxes linked to 2 cells in order to display a red or green arrow.

If you use a chart object you can conditional display points with custom markers.

Wow, thanks! It works! However though, how did you insert multipile codes into one object shape?

When I copy the shape into a different square it only uses one code "=b10" but your code it changes from =b10 to =b11

[sovietchild]

Oh I see what you did there. You have 2 diff. objects


bigstock-Thank-You-Phrases-38523424.jpg

[sovietchild]

Thanks again.

7.0 Classie-2.png

Source of inspiration http://jakesmithportfolio.com/wp-con...9.27.51-AM.png