. . . "I would like to do conditional formatting on row level when the value year (this column is a dropdown with predefined years) IS NOT today.Year -1 (The today date can be used by the formula in SPD)." .