excel根据当前时间高亮显示单元格(优化版)
=IF(AND(TEXT((NOW()),"HH:mm")-开始时间单元格>=0,结束时间单元格-TEXT((NOW()),"HH:mm")>0),TRUE,FALSE)
=IF(AND(TEXT((NOW()),"HH:mm")-A3>=0,B3-TEXT((NOW()),"HH:mm")>0),TRUE,FALSE)
=IF(AND(TEXT((NOW()),"HH:mm")-开始时间单元格>=0,结束时间单元格-TEXT((NOW()),"HH:mm")>0),TRUE,FALSE)
=IF(AND(TEXT((NOW()),"HH:mm")-A3>=0,B3-TEXT((NOW()),"HH:mm")>0),TRUE,FALSE)