Select column D > Conditional Formatting > New Rule > Use formula:
For dynamic charts that update when you add new rows, use =OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),1) to define your axis ranges. kraljic matrix excel template
If you don't want to build manually, search within Excel for under File > New – some built-in or community templates exist. Otherwise, sites like Template.net or Smartsheet offer free Excel versions. Select column D > Conditional Formatting > New
To prevent errors, the template should use Excel Data Validation to restrict categories (e.g., a dropdown for "Supplier Region" or "Unit of Measure"). Select column D >