有冇一個函數可以因為 A1=8 ,所以 B1 儲存格填滿黑色
格色化條件我只做到單格對單格,但是我有成千個要做..
我唔想重複做一千次....
我想做到係A1到A1000入邊,如果A7=8,A10=8,A300=8的話,B7,B10,B300就會填滿
黑色呢個效果
Excel 儲存格變色難題!!!
2013-10-10 5:27 am
回答 (1)
2013-10-11 9:11 pm
✔ 最佳答案
Excel 2010:conditional formatting=>new rule=>use a formula to determine which cells to format
in "Format value where this formula is true" 下面打 " =A1=8"
click Format , choose what format you like and which cell you want applies to (=$B$1)
and than click ok.
copy b1 to b2, b3..............
收錄日期: 2021-04-13 19:44:56
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20131009000051KK00263