Ben,
Use "Formula is" and enter =Find("Late by",C1) ... assuming C
is the column for CF and colour as before. Repeat for On Time and Early by.
(You can just test For Early/Late, omitting the "by").

HTH

"Ben" wrote:

Hi

It's works great when the answer is On-time,but not for when the answer is
Early by or Late by.

I think this is because these are then followed by a time i.e late by 0day &
1:00

Any ideas
Thanks
Ben

"Toppers" wrote:

Ben,
Ignore my last posting ..it won't work. I should have looked more
carefully at your formula.

"Ben" wrote:

Hi
Someone on this site previous has make up this great formula for me (see
below)
What i need now is when the following answer is displayed the text colour
changes accordingly:
On Time (blue)
Late by(Red)
Early by(green)
I believe it's to do with conditional formating but just can't work it out.
Thanks

=IF(J5+K5=N5+T5,"On-Time",IF(J5+K5N5+T5,"Early by
"&TEXT(J5+K5-(N5+T5),"d""days & ""hh:mm"),"Late by "&
TEXT(N5+T5-(J5+K5),"d""days & ""hh:mm")))