|
Featured Tutorial
Featured Macro
YouTubersLoveExcel#17: Hide Bank Rec Formula
Use 2 SUMIF functions to create to Bank Reconciling formula. Also:
1) Add Conditional Formatting with TRUE/FALSE formula that hides formula
2) Add Conditional Formatting with TRUE/FALSE formula that highlights row
3) Custom Number Formatting
4) Use an IF function to turn on and off a formula.
5) Add a Data Validation Drop-down list to a cell
1) Add Conditional Formatting with TRUE/FALSE formula that hides formula
2) Add Conditional Formatting with TRUE/FALSE formula that highlights row
3) Custom Number Formatting
4) Use an IF function to turn on and off a formula.
5) Add a Data Validation Drop-down list to a cell