Fairly new to Macro's so.....

Have placed an autoshape at the end of each row (365 rows in all) column P.
When clicked on I want all the information in that row to be printed out to
the default printer. Is there a type of macro that can do this? (I.E. Cell A3
- Cell O3 printed out on top of one another to fit on an oversized label)

Also can a conditional format be created that acknowledges when an autoshape
has been pressed and can turn the button or the cell to a different color?

Thanks in advance

Thanks