Last updated 2 years ago
Was this helpful?
ไฝฟ็จใ่ช่จๅ ฌๅผใๆ๏ผๅช่ฆๅฏซใ็ฌฌไธๅๅฒๅญๆ ผใ็ๅ ฌๅผๅฐฑๅฏไปฅโ๏ธ
ๆณจๆ๏ผๅ ฌๅผๅ้ข่ฆๆใ็ญ่ใ(=)
# ็ฌฌไธๅๅฒๅญๆ ผ็ๅ ฌๅผ # ๅฒๅญๆ ผ้็ฉบ็ฝ๏ผไธๆๅญ่ฝ็บๆธๅญๅพ๏ผๅ ถๅผ < 60 =AND(NOT(ISBLANK(C8)),VALUE(C8)<60)
ๅ ถไป็ฏไพ
# A1:A100 ๅ งๆ้่ค็ๅผ =COUNTIF($A$1:$A$100,A1)>1 # ๅ่จญ้ธๆ A:F # ไธๅ็ๆขไปถๅฏไปฅ่จญๅฎใๆดๅใ็ๆ ผๅผ(ๅฆๆ็ฌฌไธๆ ผ = 1) =$A1=1
Google Help โฉ
Work with data
Use conditional formatting rules in Google Sheets
AND function
Logical functions: NOT, OR, ...
ISBLANK function
ๅ็ญๅนณๅๅๅไธๅ - ็จ็ด ่ฒๅบ่ฒ้กฏ็คบๅนณๅไฝๆผ 60 ็ๅๆธใ