A few friends and myself have created a Google Spreadsheet where we are keeping track of virtual item sales. One column has costs, one column has income one has profit, and a fourth has a running total of funds.
I'd like to be able to make the column with profit to be very green for very large numbers, so they are visible while glancing over the document.
I know how to do this in Excel, but I can't find a way to do it in Google Spreadsheet.
Best Answer
Use the conditional format option in the menu format:
Make sure to select the complete column, when applying the conditional format. See screenshot from the example file I prepared:
Example file: Conditional Formatting. Try to add some numbers yourself add see the result. Be sure to check the settings under
Format> Conditional formatting...in the menu.