Conditional formatting

Practice with conditional formatting

⁠

Open the lesson video⁠

in a new tab.

Using one your table from the previous activities (or by typing “/answer table 2” to use ours), conditionally format your table

Click on Options on the top right of your view

Select Conditional format then Add rule

Any scale greater than 3 is blue

Any date before today is red

Apply this to the whole row

Any reaction that has been clicked (counter is greater than zero) is pink.

View of Answer Table 2

View of Answer Table 2

Tasks

Due date

Scale

Status

Check emails

4/11/2023

Not started

Send follow-ups

4/19/2023

Blocked

Eat lunch

4/25/2023

In progress

There are no rows in this table

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.