Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the appearance cell where Find criteria is found in a cell
When using Find function of Excel, in a worksheet with a lot of cells, it is
often difficult to see where the Find has pointed (which cell it has landed on). A double line border displays in the found cell, but this is not always obvious. Can we modify the Find result appearance to present a heavy colored border, or flash, or anything to make a 'weed' stand out in a field of 'daisies'? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the appearance cell where Find criteria is found in a cell
One way to do it ...
I have Excel 2002 (I don't know what other versions have this feature) - If you use Replace instead of Find, if you put the same text into the 'Replace With' box as the 'Find What' box, you can also set the Format associated with 'Replace With'. So you can designate any sort of format you want ... Rgds, ScottO "Tomszar" wrote in message ... | When using Find function of Excel, in a worksheet with a lot of cells, it is | often difficult to see where the Find has pointed (which cell it has landed | on). A double line border displays in the found cell, but this is not always | obvious. Can we modify the Find result appearance to present a heavy colored | border, or flash, or anything to make a 'weed' stand out in a field of | 'daisies'? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the appearance cell where Find criteria is found in a c
The Replace Function has Options but they are for setting the search
criteria, i.e. Color of Font, Type of Font, etc. It does nothing that I can see to make the Found cells stand out. Thanks anayway. "ScottO" wrote: One way to do it ... I have Excel 2002 (I don't know what other versions have this feature) - If you use Replace instead of Find, if you put the same text into the 'Replace With' box as the 'Find What' box, you can also set the Format associated with 'Replace With'. So you can designate any sort of format you want ... Rgds, ScottO "Tomszar" wrote in message ... | When using Find function of Excel, in a worksheet with a lot of cells, it is | often difficult to see where the Find has pointed (which cell it has landed | on). A double line border displays in the found cell, but this is not always | obvious. Can we modify the Find result appearance to present a heavy colored | border, or flash, or anything to make a 'weed' stand out in a field of | 'daisies'? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the appearance cell where Find criteria is found in a cell
maybe....
you may want to try Chip Pearson's Rowliner: http://www.cpearson.com/excel/RowLiner.htm Tomszar wrote: When using Find function of Excel, in a worksheet with a lot of cells, it is often difficult to see where the Find has pointed (which cell it has landed on). A double line border displays in the found cell, but this is not always obvious. Can we modify the Find result appearance to present a heavy colored border, or flash, or anything to make a 'weed' stand out in a field of 'daisies'? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
Cell references change when entering new data | New Users to Excel |