You can link Autoshapes that can contain text to a cell. The text in the Autoshape will change when the cell is updated.
1. Draw an Autoshape on your spreadsheet
2. In the formula bar type an equals sign (Make sure the Autoshape is still selected)
3. Click the cell you want to link to the Autoshape and hit Enter
4. Add formatting to your Autoshape
