Generates a list of cells containing text that looks like a formula (starts with an equals sign), but is formatted as text and will never be calculated.
Generates a list of cells containing formulas that start with a '-' character. For example, a formula such as: '=-B25' is ...
Generates a list of cells containing formulas with errors. On the spreadsheet, Excel will show the value of these cells as ...
Generates a list of cells containing formulas with nested IF() statements. This is an IF() statement inside of another IF() ...
Generates a list of cells containing numeric values that have been formatted as text. This will also include values that ...
Generates a list of cells containing text that looks like a formula (starts with an equals sign), but is formatted as text ...
Generates a list of cells containing unique formulas. Unique formulas are formulas that exist only once within the workbook, ...
Generates a list of cells that are not blank, and the foreground and background color have been formatted to the same color. ...
Generates a list of non-formula cells with a numeric value. For example, a cell with a constant value of '27.5' would be ...
Generates a list of non-formula cells with a textual value. For example, a cell with a constant value of 'Financials' would ...