Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) |