Thursday, January 7, 2016

Google Sheets: Conditional Formatting





(Click to download.)

This extension is great when want to capture something on your computer.  It will even delay the capture so you are able to select.  After the image is captured, you are able to edit it.  

Awesome Screenshot Tutorial








Conditional Formatting  is a tool that allows you to apply formats to a cell or range of cells and have that formatting change depending on the value of the cell or the value of a formula.

For example, if you want the failing grades to show up in red and the 70-75 grades in pink.





 To create the conditional format rules, you will need to add the rules where it says, "cell in not empty".  You can choose the default colors or customize your own.  To add more rules click on "add another rule".  


Depending on the numbers, your data will change as new number or calculations are inserted in your Google Sheet.