IF(D2="Paid","",IF(C2="","",IF(TODAY()<C2,"",IF(TO DAY()-C214,"Ove
 

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?

IF(D2="Paid","",IF(C2="","",IF(TODAY()<C2,"",IF(TO DAY()-C214,"Ove
 

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?

IF(D2="Paid","",IF(C2="","",IF(TODAY()<C2,"",IF(TO DAY()-C214,"Ove
 

"Kev" wrote in message
...
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?

Hi Kev,

Goto "FormatConditional Formatting", then from the dropdowns, Cell Value
Is, Equal To, Overdue....

Then hit the Format button, choose a colour from the dropdown.

HTH

Rich