Google Sheet Question

[Packer16]

Using Google sheets is there a way to set the print range and have sheets fit the print area?  Also, is there a way to print in color.  TIA.

 

Packer

[investor-man]

Using Google sheets is there a way to set the print range and have sheets fit the print area?  Also, is there a way to print in color.  TIA.

 

Packer

 

Hi Packer, you I don't quite understand your first question. Can you clarify? For your second question, you can click format -> conditional formatting, and setup some rules for conditional formatting. Here's a sheet where I've fetched a price for AAPL and set the background color to green if the price is greater than $100, and fetched the price for MSFT and set the text color to red if it's less than $110

 

https://docs.google.com/spreadsheets/d/1UZ8ln7lwHkI9YnCuMyV2F72pf6fwD8q_5QbdYliGMT0/edit?usp=sharing