我的问题是IF((TODAY()-B4)>0,"过期"&(TODAY()-B4)&"天",IF((B4-TODAY())=0,"证书到期",IF((B4-TODAY())<=30,(B4-TODAY())&"天后到期","未到期")))想把过期"过期&(TODAY()-B4)&"天标注... 我的问题是 IF((TODAY()-B4)>0,"过期"&(TODAY()-B4)&"天",IF((B4-TODAY())=0,"证书到期",IF((B4-TODAY())<=30,(B4-TODAY())&"天后到期","未到期"))) 想把过期"过期&(TODAY()-B4)&"天 标注成红色;证书到期 标注成红色 ;,(B4-TODAY())&"天后到期 标注成黄色,未到期 标注成绿色。请教高手指点 展开