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”)