software

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

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

quot;Kevquot; wrote:

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


quot;Kevquot; gt; wrote in message
...
gt; I'm using this formula to show quot;paid,Due or Overduequot; invoices. Is there a
gt; way
gt; I can keep the same basic formula but change the Font on OVERDUE RED?

Hi Kev,

Goto quot;Formatgt;Conditional Formattingquot;, then from the dropdowns, Cell Value
Is, Equal To, Overdue....

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

HTH

Rich