Try it again, but this time click the "Options>>" button and remove the checkmark from the "Match entire cell contents" checkbox.As the subject says I want to search for only negative values within a file. Is there a way of doing so? I tried simply putting a - in the find values area, that didnt work.
Try it again, but this time click the "Options>>" button and remove the checkmark from the "Match entire cell contents" checkbox.
It works in a very annoying manner as far as I am concerned. Once set, either manually or by VBA code, the two checkboxes retain that setting until changed. I don't mind the "sticky" nature of the setting so much as I mind the fact that you have to click a button to see the checkboxes in order to see what their setting is. If you look at the amount of information contained in panel displayed when you click the "Options>>" button, I see no reason why those settings do not simply appear on the main dialog panel.Wow that seems to have worked! Except that I pressed Ctrl-F again and I didnt see match entire cell contents checked. Maybe that's why it worked, and earlier it was checked, but I know I certainly didnt uncheck it. Not sure how that works.
After you click the "Find All" button, click into the table of found cells that appears at the bottom of the panel, press CTRL+A and then click the Close button... all of the found cells will be selected, so you can call up the Cell Format dialog box and change the format as desired and all those selected cells will inherit that new cell format. (Click any non-selected cell to clear the multi-cell selection.)Anyway so I'd wanted to do this to make sure that all my negative numbers were in ($xxx) format rather than -$xxx format. When I searched this way I saw only one result, the one which had a minus sign in it. The other negative numbers, which had brackets around them, didnt end up showing up in the search. Is that whats supposed to happen? If so, how would I find all the negative numbers, not just the ones which have a visible minus sign? But this alone should be adequate.
It works in a very annoying manner as far as I am concerned. Once set, either manually or by VBA code, the two checkboxes retain that setting until changed. I don't mind the "sticky" nature of the setting so much as I mind the fact that you have to click a button to see the checkboxes in order to see what their setting is. If you look at the amount of information contained in panel displayed when you click the "Options>>" button, I see no reason why those settings do not simply appear on the main dialog panel.
After you click the "Find All" button, click into the table of found cells that appears at the bottom of the panel, press CTRL+A and then click the Close button... all of the found cells will be selected, so you can call up the Cell Format dialog box and change the format as desired and all those selected cells will inherit that new cell format. (Click any non-selected cell to clear the multi-cell selection.)