Created attachment 122815 [details] See explanation in the file. I have this formula: =IF(EXACT($A2,$B$1), STYLE("Match"), STYLE("Default")) The result is shown as FALSE/0 with the style "Match" applied, when the condition is met, and as FALSE/0 with the style "Default" applied, when not met.