What you're asking for is handled not by cell formulas but by conditional
formatting. In the cell with this calculation, select Format Conditional
Formatting. Since the value will have been set to Overdue already, you can
make the condition Cell Value Is / Equal To / ="Overdue". Then set the font
and/or pattern as you'd like it to appear in this case.
--Bruce

"Kev" wrote:

I'm using this formula to show "paid,Due or Overdue" invoices. Is there a way
I can keep the same basic formula but change the Font on OVERDUE RED?