Audit
Audit formula consistency across rows and columns.
Input Parameters/Data
Sheet: Works on any sheet of the workbook.
Type: You can audit by row, column or a combination of both.
Cells are format filled as follows:
- PassedCells with a consistent formula based on the first formula item in relevant range.
- FailedCells with an inconsistent formula based on the first formula item in relevant range.
- BlankBlank cells between passed and/or failed cells.
Notes
Most runs are completed within 3s.
The number of impacted cells is provided.
You can localize the search by specifying start and end cells. Click the check button to activate an active cell.
Clears any regular or conditional format fill in the current sheet.
Output
Format Fill: Format fill of matching cells in current sheet.
View demo here
Learn the basics in 5 minutes with our Quick start guide. To make the most of Fontics, check out our Tips & tricks.