I'd go with Purfleet's Conditional Formatting example. You could even designate a cell (for example A1) that would contain your "looked for" date. Then you can make the Cond Form rule compare with $A$1. Then enter a date in A1 and press Enter.