Due in Days and conditional formatting question

afelo

I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to have it display no number once the task has been completed, or at least remove the red font once the "Status" column dropdown menu selection is "Completed".

=IFERROR(NETWORKDAYS(TODAY(), [Actual End Date \[Launch Date\]]@row), "")

I would really appreciate some help with this, Thank you!!

Paul Newcome

You would use an IF statement like so:

=IFERROR(IF(NETWORKDAYS(.......)< 0, NETWORKDAYS(.......)), "")