"m3s3lf" wrote in
message ...

I appreciate the response, especially so quickly, but...

conditional formatting doesn't work across 2 different sheets, and I
don't want it to always be highlighted... only when the user clicks the
button.

Of course it will, see this example

http://cjoint.com/?fClCwKV8Zw