Create two calculated fields:
Colour: if F3<0 then 'Red' else 'Green' endif F3<0 then 'Red' else 'Green' end
Arrow :if F3<0 then 'Down' else 'Up' endif F3<0 then 'Down' else 'Up' end
Create two sheets, one with each of the above fields.
Add them in a dashboard and do necessary formatting.
Check out my workbook to see how you can actually embed all of the info (including the up/down arrows) inside of a box, just like you wanted.
Thank you very much Mixon. This is what I was looking for.