ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Find (https://www.excelbanter.com/new-users-excel/216232-find.html)

Connie in Vegas[_2_]

Find
 
When selecting a column and using the Find command, it is hard to see where
the cell is. The color of the cell and the highlight of selecting the column
are so close that it is hard to recognize when excel finds what I am looking
for. Is there a way to set it up where it selects the cell giving it the
dark outline when it finds the information I am looking for. Or maybe change
the color of the selected cells to be darket?

JLatham[_2_]

Find
 
You're using Excel 2007, right? This is a common complaint. There isn't a
lot to be done with changing color schemes. You can get better highlighting
with some VBA code. Since you're posting in the New Users area, I'm betting
that kind of frightens you. So, you might look into Chip Peterson's
RowLiner add-in which has the code in it! Check out his page with it he
http://www.cpearson.com/excel/RowLiner.htm
Good Luck.

"Connie in Vegas" wrote in message
...
When selecting a column and using the Find command, it is hard to see
where
the cell is. The color of the cell and the highlight of selecting the
column
are so close that it is hard to recognize when excel finds what I am
looking
for. Is there a way to set it up where it selects the cell giving it the
dark outline when it finds the information I am looking for. Or maybe
change
the color of the selected cells to be darket?



Suleman Peerzade[_2_]

Find
 
you can also try with auto filters that will also work for you
--
Thanks
Suleman Peerzade


"Connie in Vegas" wrote:

When selecting a column and using the Find command, it is hard to see where
the cell is. The color of the cell and the highlight of selecting the column
are so close that it is hard to recognize when excel finds what I am looking
for. Is there a way to set it up where it selects the cell giving it the
dark outline when it finds the information I am looking for. Or maybe change
the color of the selected cells to be darket?


Connie in Vegas[_2_]

Find
 
Thank you for your help. I think I will try the rowLiner Add-In.

"Suleman Peerzade" wrote:

you can also try with auto filters that will also work for you
--
Thanks
Suleman Peerzade


"Connie in Vegas" wrote:

When selecting a column and using the Find command, it is hard to see where
the cell is. The color of the cell and the highlight of selecting the column
are so close that it is hard to recognize when excel finds what I am looking
for. Is there a way to set it up where it selects the cell giving it the
dark outline when it finds the information I am looking for. Or maybe change
the color of the selected cells to be darket?



All times are GMT +1. The time now is 12:59 PM.

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