change the text color

[saralee]

Hi,

I have a number field that I'm giong to change the text color if the value is in a certain range. I don't know how to use the TextColor function in my script.. this wouldn't work-

SetField(household::days; textcolor(255;0;0))

What should it be?

Thanks!

[TheTominator]

The calculation should be:

TextColor(household::days; RGB(255;0;0))

[comment]

Why not use conditional formatting?

http://www.filemaker.com/help/html/edit_layout.10.13.html#1028330

[saralee]

thanks, comment!

Edited August 20, 2010 by Guest

[almedajohnson]

Conditional formatting is the best option as i have used many times and it really helpful even in future.