Adding colour in a formula

Thanks Bob
the formula works great,is it possible for when the answer is displayed the
text colour can change for example

Late - would be red
Early - would be blue
On-time - would be green

Thanks
Ben


"Bob Phillips" wrote:

> =IF(A1+B1=C1+D1,"On Time",IF(A1+B1>C1+D1,"Early by "&TEXT(A1+B1-(C1+D1),"d
> ""days ""hh:mm"),"Late by "&TEXT(C1+D1-(A1+B1),"d ""days ""hh:mm")))
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Ben" <Ben@discussions.microsoft.com> wrote in message
> news:7E5A6359-6981-47AC-8F1F-E35081BD442F@microsoft.com...
> > Hi,
> >
> > Is it possible for a formula to calculate the diffence between seperate
> > cells.For example can A&B & D&E be read as one.The answer i'm looking for
> in
> > F is LATE BY 1day 2hr. If they match to read ON-TIME, and if early to
> read
> > EARLY BY and enter time
> >
> > Expected Actual
> > Answer
> > A B D E F
> > 05/03/2006 12:00 06/03/2006 14:00
> >
>
>
>

This could be done using Conditional Formatting.

Select the cell your formula is in (I'll assume F1 for this example).
Choose "Conditional Formatting" from the Format Menu
Change "Cell Value Is" to "Formula Is"
Enter the formula: =LEFT(F1,1)="L"
Choose your format (red font color)
Click "ADD" to set a second condition
Change "Cell Value Is" to "Formula Is"
Enter the formula: =LEFT(F1,1)="E"
Choose your format (blue font color)
Click "ADD" to set a third condition
Change "Cell Value Is" to "Formula Is"
Enter the formula: =LEFT(F1,1)="O"
Choose your format (green font color)
Click OK

That should do it!
HTH,
Elkar


"Ben" wrote:

> Thanks Bob
> the formula works great,is it possible for when the answer is displayed the
> text colour can change for example
>
> Late - would be red
> Early - would be blue
> On-time - would be green
>
> Thanks
> Ben
>
>
> "Bob Phillips" wrote:
>
> > =IF(A1+B1=C1+D1,"On Time",IF(A1+B1>C1+D1,"Early by "&TEXT(A1+B1-(C1+D1),"d
> > ""days ""hh:mm"),"Late by "&TEXT(C1+D1-(A1+B1),"d ""days ""hh:mm")))
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "Ben" <Ben@discussions.microsoft.com> wrote in message
> > news:7E5A6359-6981-47AC-8F1F-E35081BD442F@microsoft.com...
> > > Hi,
> > >
> > > Is it possible for a formula to calculate the diffence between seperate
> > > cells.For example can A&B & D&E be read as one.The answer i'm looking for
> > in
> > > F is LATE BY 1day 2hr. If they match to read ON-TIME, and if early to
> > read
> > > EARLY BY and enter time
> > >
> > > Expected Actual
> > > Answer
> > > A B D E F
> > > 05/03/2006 12:00 06/03/2006 14:00
> > >
> >
> >
> >
>

Ben, I responded in the original thread.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ben" <Ben@discussions.microsoft.com> wrote in message
news:332B693C-77F9-420A-B972-DEAA571C8965@microsoft.com...
> Thanks Bob
> the formula works great,is it possible for when the answer is displayed
the
> text colour can change for example
>
> Late - would be red
> Early - would be blue
> On-time - would be green
>
> Thanks
> Ben
>
>
> "Bob Phillips" wrote:
>
> > =IF(A1+B1=C1+D1,"On Time",IF(A1+B1>C1+D1,"Early by
"&TEXT(A1+B1-(C1+D1),"d
> > ""days ""hh:mm"),"Late by "&TEXT(C1+D1-(A1+B1),"d ""days ""hh:mm")))
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "Ben" <Ben@discussions.microsoft.com> wrote in message
> > news:7E5A6359-6981-47AC-8F1F-E35081BD442F@microsoft.com...
> > > Hi,
> > >
> > > Is it possible for a formula to calculate the diffence between
seperate
> > > cells.For example can A&B & D&E be read as one.The answer i'm looking
for
> > in
> > > F is LATE BY 1day 2hr. If they match to read ON-TIME, and if early
to
> > read
> > > EARLY BY and enter time
> > >
> > > Expected Actual
> > > Answer
> > > A B D E F
> > > 05/03/2006 12:00 06/03/2006 14:00
> > >
> >
> >
> >
>