Text in a cell in Excel is called a text string. Excel provides a number of built-in functions enabling you to select and manipulate text strings in cells. The easiest way to identify or extract a ...

Over time, these Excel spreadsheets can grow to enormous sizes, making it difficult to manually find cells with certain conditions.

In case of an error, a triangle appears in the corner of the cell. You can change the Color of an Error Indicator from green to any other in Excel.

Select the cell range where the text color needs to be replaced. If it is the entire spreadsheet, do not select anything. Click on the Find and Select dropdown within the Editing toolbar in the ...

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

Highlighting cells with different colors can help you quickly identify information in a spreadsheet. Excel also lets you sort by color to easily group all the information you’ve highlighted with a ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.