再問Excel conditional formatting

本帖最後由 Olympian 於 2015-11-4 15:21 編輯

我用Libre office整左幾個conditional formatting嘅rule
但我將佢copy過Excel就用唔到
請幫我睇下D formula有咩問題?
  1. AND(NOT(B5=0),MROUND(($G$2-B5),0.25)-($G$2-B5)>=-0.01,MROUND(($G$2-B5),0.25)-($G$2-B5)<=0.01)
複製代碼
  1. AND(NOT(B5=0),OR(AND(MROUND(($G$2-B5),0.25)-($G$2-B5)>0.01,MROUND(($G$2-B5),0.25)-($G$2-B5)<=0.02),AND(MROUND(($G$2-B5),0.25)-($G$2-B5)<-0.01,MROUND(($G$2-B5),0.25)-($G$2-B5)>=-0.02)))
複製代碼
我係想將G2的值減該格的值再同0.25的倍數比較,相差少過0.01的就format青色,少過0.02就format綠色

同埋我在Excel2010的condtional formatting改唔到長formula,我按左右,ctrl-A,home,end都郁唔到個cursor
我唯有長按delete刪哂全部再paste過,有無好D嘅方法做呢樣野?

謝謝