您可以设置单元格格式根据您指定的条件而改变。

You can set up cell formats to change depending on conditions that you specify.

youdao

如果我将单元格格式化为日期英语(NZ)，它会在电子表格中显示，但是当我尝试上传时，它改变了日期和月份。

If I format the cell as date English (NZ) it displays right in the spreadsheet, but when I try to upload it switched the day and month.

youdao

接着要做的事情是添加第二个规则，设置数值小于80的单元格格式，格式为“自动”（默认主题里是透明单元格里的黑色文本）。

The next thing to do is to add a second rule that formats values that are less than 80, and set the format to "Automatic" (black text on transparent cells for the default theme).

youdao