Chris

You can't unfortunately. I have reported to MS and hopefully it will get
fixed in SP1 or the next version as I totally agree, particularly when using
find

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Cowboy" wrote in message
...
How do I change the highlight color of a cell when it finds what I search
for? Right now I select an entire column, or a whole page, and do my
search.
It finds what I'm looking for, but it highlights it barely a shade
different
than the select highlight.

Excel 2007

-Chris