Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|