Text Styles in formulas

[armchairandy]

Hi

Im using a simple if then formula to compare Planned % against Actual %. I
then use the graphical indicator to show if its behind or not, I also use a
text field to do the same:
IIf([Number19]=100,"Completed",IIf([Number18]=0,"Not Due to
Start",IIf([Number19]<[Number18],"Behind
Programme",IIf([Number19]>[Number18],"Ahead of
Programme",IIf([Number19]=[Number18],"On Programme")))))

How would I make the text bold and have different colours for each Status ???

Andrew

 

[John]

Andrew,
I don't work much with formulas but as far as I know text formatting
cannot be done with a formula. You will either need to do it manually,
or in my opinion VBA would be a much more flexible method for doing what
you want. With VBA you can do basically anything you want, including
text formatting.

Hope this helps.
John