@Conrad_Fink Hi Conrad, the setting “If this condition is true” is a true/false check to determine whether or not the format rule will be applied. In your case, this condition is derived from the date of the row. For example, if you only want to highlight the row on Sundays, you can use this expression:
WEEKDAY(TODAY()) = 1
The expression WEEKDAY() returns a number that represents a day of the week of a particular date. Days are counted from Sunday, so Sunday will be 1.
Depending on the logic that you want to implement, you will need to modify the condition expression accordingly. It’s important to note that the expression must be valid and must return a yes/no, or true/false result. In the screenshot, your expression “true=TODAY()” is invalid because you cannot compare the value “true” to a date.