Excel Forum
Similar Content
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...
Determine if a Cell Contains a Function in Excel - Great for Conditional Formatting and Validation - UDF
Macro: Determine if a cell in Excel contains a formula or function with this UDF (user defined fu...
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...

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.


Got a Question? Ask it Here in the Forum.