Repeating Highlight of Weekends in Table View
I'm using FMP 10. I have one page that I often view in Table view with all dates listed vertically in the first column on the left. I have managed to get it to highlight the current date with a specific color to spot it easily. What I would like to do now is highlight every Saturday and Sunday in say a yellow. We book a lot of stuff on weekends and this would help greatly. I'm stuck. The formula seems to be eluding me. Is this not something that would fall under Conditional Formatting?
Use this expression in your conditional format:
DayofWeek ( YourTable::YourDateField ) = 1 /* Sunday */ or DayofWeek ( YourTable::YourDateField ) = 7 /* Saturday */
You can use the above expression with any field in your table row to set a text color, fill color or text format.