July 21, 200916 yr 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.
July 21, 200916 yr 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.
July 22, 200916 yr 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.
Create an account or sign in to comment