ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   highlighting a search cell (https://www.excelbanter.com/excel-discussion-misc-queries/165142-highlighting-search-cell.html)

Cowboy

highlighting a search cell
 
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

Nick Hodge[_2_]

highlighting a search cell
 
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



Cowboy

highlighting a search cell
 
Thank you very much Nick. Not the answer I wanted, but I thank you for the
response just the same. Any clues when SP1 will be released?


-Chris

"Nick Hodge" wrote:

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



Peo Sjoblom

highlighting a search cell
 
It's in limited beta at the moment


--


Regards,


Peo Sjoblom


"Cowboy" wrote in message
...
Thank you very much Nick. Not the answer I wanted, but I thank you for
the
response just the same. Any clues when SP1 will be released?


-Chris

"Nick Hodge" wrote:

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






All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com