我對谷歌電子表格非常陌生，并且conditional Formatting僅在第一列值為日期時才嘗試使用突出顯示行。
- 共享公共谷歌電子表格：https : //docs.google.com/spreadsheets/d/10NzbtJhQj4hQBnZXcmwise3bLBIAWrE0qwSus_bz7a0/edit#gid=1405439211
我的嘗試
=not (isblank($A4))
// This is not working.
// But A4 is not fixed, on a new day if I insert some rows, $A4 might be $A5 and it may not work.
示例谷歌表
- 此作業表有兩列
Date和Contents。 - 我只想在第一個值是日期時突出顯示行，如下所示
Date Contents
Dec 22 hello --> highlight this row, since it has date on column Date
hi ---> don't hightlight this
Dec 21 This is another data and needs to be highlighted
dont highlight me
dont highlight me
Dec 20 highlight me
And so on.
uj5u.com熱心網友回復：
試試這個公式
=$A1<>""
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/390169.html
上一篇：過濾后如何更新GoogleAppScript中的單元格
下一篇：C# 將PDF轉為線性化PDF