根據 C2:C 列中單個單元格中的多個奇異日期，通過條件格式突出顯示 G2:Z 列中的多個單元格 =ArrayFormula(OR((SUBSTITUTE(SPLIT($C2, CHAR(10)), ".", "/")*1)=G$1))
但我正在尋找一種方法，通過條件格式仍然突出顯示 G2:Z 列中的多個單元格，但基于 C2:C 列中包含日期范圍 單數日期的單個單元格。
樣本表：
uj5u.com熱心網友回復：
在這種情況下應該作業：
=ArrayFormula(
OR(
(G$1=SUBSTITUTE(SPLIT(TRANSPOSE(SPLIT($C2,CHAR(10)))," - "),".","/")*1)
(G$1>=INDEX(SUBSTITUTE(SPLIT(TRANSPOSE(SPLIT($C2,CHAR(10)))," - "),".","/")*1,0,1))*
(G$1<=IFERROR
(
INDEX(SUBSTITUTE(SPLIT(TRANSPOSE(SPLIT($C2,CHAR(10)))," - "),".","/")*1,0,2),
INDEX(SUBSTITUTE(SPLIT(TRANSPOSE(SPLIT($C2,CHAR(10)))," - "),".","/")*1,0,1))
)
)
)
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/343992.html