Adding colour in a formula

[Ben]

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

 

[Elkar]

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

 

[Bob Phillips]

Ben, I responded in the original thread.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)