google-sheets - Conditional formatting on google sheet

Question

I need to format A1 when

• B1 is empty and A1 is lower than today

A1 is a date, like a deadline that I will print red if the deadline is not reached. B1 is the cell used to say it was done.

标签： google-sheets

Answer 1

转到条件格式并使用自定义公式=and(A1<today(),B1="") 您也可以将背景颜色设置为红色。

编辑：要将格式扩展到列但不超出日期范围，您可以应用到范围 A:A 并将公式修改为=and(isDate(A1),A1<today(),B1="")

这是一张图片