How do I change the color coding with Find & Replace?

J

JimG

I am using Excel 2007 and I am color blind. In 2003 I always had a hard time
spotting the cell returned when using the "Find" portion of "Find & Replace".
With 2007 it is impossible for me see which cell is highlighted.

Is there a way to change the settings for this function?
 
J

Jim Cone

Chip Pearson has cell highlight code and a row highlighter add-in
at his website...
http://www.cpearson.com/excel/excelM.htm#HighlightActiveCell

For what it is worth, my free "Determine Colors" add-in which
displays the name of the cell interior, border and font colors when
you right-click a cell is available here...
http://excelusergroup.org/media/
(it includes conditionally formatted colors)
Picture shown here...
http://i258.photobucket.com/albums/hh247/James_Cone/DetermineColorsPicture.jpg
--
Jim Cone
Portland, Oregon USA


"JimG" <[email protected]>
wrote in message
I am using Excel 2007 and I am color blind. In 2003 I always had a hard time
spotting the cell returned when using the "Find" portion of "Find & Replace".
With 2007 it is impossible for me see which cell is highlighted.

Is there a way to change the settings for this function?
 
C

CurlyDave

I am using Excel 2007 and I am color blind. In 2003 I always had a hard time
spotting the cell returned when using the "Find" portion of "Find & Replace".
With 2007 it is impossible for me see which cell is highlighted.

Is there a way to change the settings for this function?

I don't use xl'07 yet but I would assume the shading would be the same
regardless if you use the find command or if you are just selecting a
cell.
Maybe this could work, not sure though
1. Click the Microsoft Office ButtonButton image, and then click
Excel Options at the bottom of the window.
2. Click Popular, and then click the Color scheme that you want.
Found it at this site
http://office.microsoft.com/en-us/excel/HA101749121033.aspx#11

Another way would be to use VBA to High lite the active cell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top