CTRL+F contrast problem - can't identify found cell

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,735
i can not see the found cell in a highlighted column when using Ctrl F. I'm using Windows XP, Microsoft Office 2007 Professional. When I highlight a column, the highlighted color is so light that when I do a "Find" CTrl+F command and it finds the value I can't see where the value is highlighted. Is there any way I can darken the highlight used when selecting the range in which you want to search?I Changing the color scheme for the entire program doesn't help. I have resorted to doing a Find All for the moment. Any other ideas
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,713
Office Version
2010
Platform
Windows
You could look in the Names box, left of the Formula bar, to see the address of the selected cell. Or observe that the row header and column header are both highlighted.
 

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,735
Names Box - yes could do that. looking for the highlighted row and coolumn headers - won't work when the column is highlighted as the range before searching. if the whole column is selected, all row numbers at left are highlighted even after searching.
 

Forum statistics

Threads
1,081,556
Messages
5,359,552
Members
400,533
Latest member
fpenning

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top