I'm confused!

[Pat]

I've looked, and haven't found an answer to this question.

Say that a date field is black, bolded. You want a conditional format that evaluates the date in the field, and if past today's date, changes the color to gray and removes the bolding.

If you use text functions in a formula, eg TextColor or TextStyleRemove, do you check the relevant button on the conditional dialogue, eg Text Color & Bold, or leave it unchecked?

Would not the formula be:

Case (

Self < Get ( CurrentDate ) ;

TextStyleRemove ( TextColor ( Self ; RGB ( 206 ; 206 ; 207 ) ) ; Bold )

)

Yet it doesn't work, whether I check the button or not.

Thanks for any suggestions.

[comment]

Would not the formula be: ...

If you are speaking of Filemaker's conditional formatting, then no. The formula needs to specify the conditions for the formatting - not the formatting itself.

Unfortunately, it's not possible to conditionally remove a style - styles like bold, italic, etc, are added to what's already set in the layout and previous conditions. I believe your best option is to turn the logic around.

[Pat]

Rats! Wish it could happen. Thanks for the help.

[comment]

But it CAN happen - if you only do things in the opposite order: format the field as plain text and set it to go bold when it is less than or equal to current date.