In Google Sheets, cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. Teachers can use this feature to highlight standout or failing grades, specific form entries that were completed on a certain date or mention you by name, and so much more. Select all the rules available for conditional formatting.

In Google Sheets, cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. Teachers can use this feature to highlight standout or failing grades, specific form entries that were completed on a certain date or mention you by name, and so much more. Select all the rules available for conditional formatting.

• date is
• is empty
• custom formatting is
• text contains
• custom formula is
• is not empty

 

Explanation:

In Google Sheets, the available rules for conditional formatting are:

date is

is empty

text contains

custom formula is

is not empty

Please note that “custom formatting is” is not a rule available for conditional formatting in Google Sheets. The other five options are all valid rules that can be used. Conditional formatting is a powerful tool that can help to visually analyze data, detect issues, and highlight important information. It’s particularly useful in educational settings, as you mentioned.