Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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+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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding colour in a formula
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+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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Colour Within Formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Change Font Colour Automatic When Formula Match | Excel Discussion (Misc queries) | |||
Formula to change rows a different colour? | Excel Worksheet Functions |