Hi,
Is it possible to change the following CF formula to show no formatting if the cell S13 is ""
S13 does have a formula
=IF($C$13="","",IFERROR(LOOKUP(2,1/(Expediting!$L$12:$L$10002=O13)/(Expediting!$F$12:$F$10002=G13),(Expediting!$C$12:$C$10002)),""))
The CF formula is
=WORKDAY($S13,3)<=TODAY()
many thanks
Is it possible to change the following CF formula to show no formatting if the cell S13 is ""
S13 does have a formula
=IF($C$13="","",IFERROR(LOOKUP(2,1/(Expediting!$L$12:$L$10002=O13)/(Expediting!$F$12:$F$10002=G13),(Expediting!$C$12:$C$10002)),""))
The CF formula is
=WORKDAY($S13,3)<=TODAY()
many thanks