Excel Forum



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.





Got a Question? Ask it Here in the Forum.