Recently I was looking through a spreadsheet to find the numbers that were in red text. Now, while that was rather visible, the spreadsheet was huge and there was a large number of rows between each red entry. While an earlier TechBits article showed how to sort by text color, that wasn't an option in this case since there were subtotals that would have been messed up by resorting the page.
Because I knew you could sort by color, I figured I could probably search by color too and I was right. There are a lot of extra Find options actually, you just don't see a number of them because they hide behind the Options button.
Because I knew you could sort by color, I figured I could probably search by color too and I was right. There are a lot of extra Find options actually, you just don't see a number of them because they hide behind the Options button.
If you open the Find window in Excel and click on the Options button on the right hand side just above the Close button, you'll see a number of the Find options. The ones I've used most often have been: (rest of article...)
