Adding colour in a formula
Ben, I responded in the original thread.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"Ben" wrote in message
...
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+B1C1+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" wrote in message
...
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
|