|
|
Featured Tutorial
Featured Macro
YouTubersLoveExcel 29 Conditional Formatting & LEFT function
Apply Conditional Formatting with the LEFT function to add color to a cell depending on the Customer selected from a Data Validation Dropdown List.
1) Data Validation
2) Conditional Formatting & LEFT function because only the first three letters of the Customer Id is required for the formatting to be applied
3) TRUE/FALSE formula that applied Conditional Formatting.
Formula.
1) Data Validation
2) Conditional Formatting & LEFT function because only the first three letters of the Customer Id is required for the formatting to be applied
3) TRUE/FALSE formula that applied Conditional Formatting.
Formula.