Conditional Formatting
With conditional formatting, you can easily track the KPIs using colored cells. You can change the color of a row, column, or cell if the data meets some conditions, but only if the word or number in the cell contains the given word or number. It makes the spreadsheet dynamic and makes you read the content with ease.
For instance, you can format a google sheet so that it would be easy to highlight the poor performance of employees you have put in the sheet, low grades, or minus numbers obtained after doing the calculations.
You can do the conditional formatting by following these steps:
- You can open the spreadsheet using Google Sheets.
- Select the total number of cells you want to apply conditional formatting.
- Click Format→Conditional formatting.
- On the pop-up menu, add a rule:
- Single color – Under the format cells if you select the condition. Under formatting style, you can choose the color and style of the text or the cell.
- Color scale- Under preview, you can select the color scale. Set the color to minimum and maximum values.
- Click Done.
How to Use Google Sheets Like a Spreadsheet Wizard: Formulas, Functions, and Formatting Tips
Google Sheets is a must for storing data in cells. These sheets are free online software. You can create and edit spreadsheets online and share them with many team members through the browser without using the MS Office suite. It is perfect for you to collaborate in real-time.
Multiple team members can simultaneously work on the same Google sheet and save everything automatically. Working on the Google sheet will save a lot of your valuable time. Here are a few tips that you can follow to use the spreadsheet like a wizard.
Link: https://www.google.com/sheets/about/
Table of Content
- Tips and Tricks to Use Google Sheets
- 1. Freeze Rows and Columns
- 2. Conditional Formatting
- 3. Use Alternate Colors
- 4. Make Use of Add-ons
- 5. Make use of a Template
- 6. Put Comments and Notes
- 7. Check Version History
- 8. Create Sum Formula
- 9. SUMIF
- 10. Average
- 11. Sort
- 12. TEXT
- Conclusion
- FAQs – Google Sheets