View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kenny A. Kenny A. is offline
external usenet poster
 
Posts: 3
Default How do I change the color the cell becomes when doing a FIND

Gord,
Thanks so much. That did exactly what I needed.
Kenny

"Gord Dibben" wrote:

Additional info.

If you have multiple "finds" from your editfind you can highlight all of
them by hitting CTRL + a with "Found" dialog open to select all "founds".

Then fill color.


Gord Dibben MS Excel MVP

On Tue, 06 Apr 2010 10:35:17 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

After you have hit the Find button and cell has been found simply hit the
Fill color Icon.


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 08:37:01 -0700, Kenny A.
wrote:

When I do a FIND or FIND / REPLACE, when Excel finds the value I am looking
for, it highlights the cell, but the highlighted cell is in white, which is
the standard sheet background. How can I change a setting so anytime I try to
do a find, when the cell is found, it shows this cell in a totally different
color say purple or red or yellow etc.. I find sometimes trying to identify
which cell it has selected in a full screen of data can be tough. I jst want
to be able to locate the selected cell easier.

Thanks for your help


.