I don’t do much Excel, but when I do, it’s crap like this. Putting it here, so I remember. For applying conditional formatting to an entire sheet, do “Applies to: =$1:$1048576” For matching exact values to conditionally format, do something like =EXACT(A1;”Foo”)