flâneur

在 Google 試算表中使用條件式格式設定規則 - 電腦 - 文件編輯器說明

support.google.com · 783 words · saved by 1 readers

Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number.

Use conditional formatting rules in Google Sheets Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number. On your computer, open a spreadsheet in Google Sheets . Select the cells you want to apply format rules to. Click Format Conditional formatting . A toolbar will open to the right. Create a rule. Single color : Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met. Color s

saved by

related reading