IF(D2="Paid","",IF(C2="","",IF(TODAY()<C2,"",IF(TODAY()-C2>14,"Ove

K

Kev

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?
 
B

bpeltzer

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
 
R

Rich

Kev said:
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?
Click to expand...

Hi Kev,

Goto "Format>Conditional Formatting", then from the dropdowns, Cell Value
Is, Equal To, Overdue....

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

HTH

Rich
 
Top