f4格填入 =if(e4="未到期","未到期",if(e4>90,"上门催讨","发函催讨"))向下填充
在F4单元格中输入：=if(AND(E4<=90,E4>0),"发函催讨",if(E4>90,"上门催讨","未到期")下拉复制该单元格即可；
=IF(TODAY()-D4>90,"上门催款",IF(TODAY()-D4>0,"发函催款","未到期"))下拉公式
你试试看格式命令中的条件格式看看啦
