Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default How do I change the color coding with Find & Replace?

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,549
Default How do I change the color coding with Find & Replace?


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

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/h...orsPicture.jpg
--
Jim Cone
Portland, Oregon USA


"JimG"
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?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 206
Default How do I change the color coding with Find & Replace?

On Feb 10, 4:53*pm, JimG wrote:
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/ex...121033.aspx#11

Another way would be to use VBA to High lite the active cell
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Default Setting-Find & Replace-How? Roy Sprunger Excel Discussion (Misc queries) 7 February 17th 08 06:19 PM
why can't I change the date with find and replace in this formula MLTDebbie Excel Worksheet Functions 0 January 30th 08 08:52 PM
Change Excel Find & Replace Options Defaults Rocky Lane Excel Discussion (Misc queries) 1 March 29th 06 03:39 PM
Find and replace of word causes change of font formatting jwa90010 New Users to Excel 4 July 22nd 05 08:10 PM
How do I find highest number in a row and change color? pamstolen Excel Worksheet Functions 3 January 18th 05 12:35 AM


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"