EXCEL中if函数颜色设定
我的问题是IF((TODAY()-B4)>0,"过期"&(TODAY()-B4)&"天",IF((B4-TODAY())=0,"证书到期",IF((B4-TODAY())...
我的问题是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())&"天后到期 标注成黄色,未到期 标注成绿色。请教高手指点 展开
展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询